sqlserver创建备份表语句

以下是创建SQL Server备份表的语句：

CREATE TABLE BackupLogs
(
BackupID INT IDENTITY(1,1) PRIMARY KEY,
BackupName VARCHAR(100) NOT NULL,
BackupType VARCHAR(50) NOT NULL,
BackupLocation VARCHAR(1000) NOT NULL,
BackupSize INT NOT NULL,
BackupDate DATETIME NOT NULL
)