Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @backupSetId AS INT
- DECLARE @Filename NVARCHAR(256)
- DECLARE @Database NVARCHAR(256)
- DECLARE @Backup NVARCHAR(256)
- SET @Database = N'dbname'
- SET @Filename = N'E:\Backup\dbname.' +
- REPLACE(CONVERT(NVARCHAR, GETDATE(), 102), '.', '-') +
- N'.bak'
- SET @Backup = @Database + N' Full Database Backup'
- BACKUP DATABASE @Database
- TO DISK = @Filename
- WITH NOFORMAT, NOINIT,
- NAME = @Backup,
- SKIP, NOREWIND, NOUNLOAD, STATS = 10
- SELECT @backupSetId = position
- FROM msdb..backupset
- WHERE database_name = @Database
- AND backup_set_id =
- (SELECT MAX(backup_set_id) FROM msdb..backupset
- WHERE database_name=@Database )
- IF @backupSetId IS NULL
- PRINT N'Verify failed. Backup information for database ''' +
- @Database + N''' not found.'
- ELSE
- RESTORE VERIFYONLY FROM DISK = @Filename
- WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement