Advertisement
Guest User

Untitled

a guest
May 13th, 2010
247
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.88 KB | None | 0 0
  1. DECLARE @backupSetId AS INT
  2. DECLARE @Filename NVARCHAR(256)
  3. DECLARE @Database NVARCHAR(256)
  4. DECLARE @Backup NVARCHAR(256)
  5.  
  6. SET @Database = N'dbname'
  7. SET @Filename = N'E:\Backup\dbname.' +
  8.     REPLACE(CONVERT(NVARCHAR, GETDATE(), 102), '.', '-') +
  9.     N'.bak'
  10. SET @Backup = @Database + N' Full Database Backup'
  11.  
  12. BACKUP DATABASE @Database
  13. TO DISK = @Filename
  14. WITH NOFORMAT, NOINIT,
  15. NAME = @Backup,
  16. SKIP, NOREWIND, NOUNLOAD, STATS = 10
  17.  
  18. SELECT    @backupSetId = position
  19. FROM    msdb..backupset
  20. WHERE    database_name = @Database
  21. AND        backup_set_id =
  22.     (SELECT MAX(backup_set_id) FROM msdb..backupset
  23.         WHERE database_name=@Database )
  24.  
  25. IF @backupSetId IS NULL
  26.     PRINT N'Verify failed. Backup information for database ''' +
  27.         @Database + N''' not found.'
  28. ELSE
  29.     RESTORE VERIFYONLY FROM  DISK = @Filename
  30.     WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement