2008维护计划生成的差异备份脚本,你看看有多少不能用的,我没2000的环境EXECUTE master.dbo.xp_create_subdir N'E:\BackupFiles\test' GO BACKUP DATABASE [test] TO DISK = N'E:\BackupFiles\test\test_backup_2013_09_18_033047_4590611.dif' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'test_backup_2013_09_18_033047_4590611', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10 GO declare @backupSetId as int select @backupSetId = position from msdb..backupset where database_name=N'test' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'test' ) if @backupSetId is null begin raiserror(N'Verify failed. Backup information for database ''test'' not found.', 16, 1) end RESTORE VERIFYONLY FROM DISK = N'E:\BackupFiles\test\test_backup_2013_09_18_033047_4590611.dif' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
如果是Maintenace Plans,那么哪里能区别是完全备份还是差异备份呢?
我有看到过Jobs中写脚本的,但是这里没有清空N天前的备份文件的功能啊?
我想说的是你的这个和SQL 05差不多,我还是再研究研究看吧!事实上我已经把Plans中所有能点过的按钮都点过了
GO
BACKUP DATABASE [test] TO DISK = N'E:\BackupFiles\test\test_backup_2013_09_18_033047_4590611.dif' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'test_backup_2013_09_18_033047_4590611', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'test' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'test' )
if @backupSetId is null begin raiserror(N'Verify failed. Backup information for database ''test'' not found.', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N'E:\BackupFiles\test\test_backup_2013_09_18_033047_4590611.dif' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND