Facing Problem regarding Verify of Backup

• 
  Hi sugam,
  
  Thank you for your forum post.
  
  The following syntax can be used to perform a verification of a SQL Backup backup file :
  
  EXECUTE master..sqlbackup N'-SQL "RESTORE VERIFYONLY FROM DISK = ''C:\Backup\pubs.sqb''"'
  
  Hope this helps.

  Matthew Flatt June 25, 2008 10:10

  - 0 +
• 
  We too are seeing that the verify step under V 5.2 and 5.3 is taking longer and longer to run. The verify is needed as part of the backup step so would it be possible to have some sort of verify parameters to make this step run faster?
  
  We are starting to use Threadcount but this affects the whole backup job. I am suggesting perhaps a way of having a verifycount for just the verify process or something similar.
  
  Thanks
  
  Chris

  ChrisAVWood June 30, 2008 10:50

  - 0 +
• 
  The OP was mistaken when he mentioned that the verification process took longer than the backup. From the logs he sent, it was clearly not so.
  
  The verification may take longer over time, if the backups are also getting larger.

  petey July 01, 2008 12:40

  - 0 +

Add comment

Please sign in to leave a comment.