SQL数据库备份历史记录表结构sys_BackupHistory

  SQL数据库备份历史记录表结构sys_BackupHistory

SQL Code:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[sys_BackupHistory](
  [isid] [int] IDENTITY(1,1) NOT NULL,
  [DBName] [varchar](50) NULL,
  [BackupFileName] [nvarchar](100) NULL,
  [BackupPath] [nvarchar](250) NULL,
  [BackupTime] [datetime] NULL,
  CONSTRAINT [PK_sys_BackupHistory] PRIMARY KEY CLUSTERED
  (
    [isid] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    
    SET ANSI_PADDING OFF
    GO
    
    
    
    
    //来源:C/S框架网 | www.csframework.com | QQ:23404761

---

扫一扫加微信