34,590
社区成员
发帖
与我相关
我的任务
分享
Select * from msdb.dbo.backupset
Select * from msdb.dbo.restorehistory
--备份时的日期
DECLARE @RQ VARCHAR(8)
SET @RQ=CONVERT(VARCHAR(8),GETDATE(),112)
EXEC ('BACKUP DATABASE SampleDB TO DISK=''E:\DataBaseBackup\SampleDB'+@RQ+'''')
Select * from msdb.dbo.backupset
Select * from msdb.dbo.restorehistory