Do SQL has any feature to test restore job like "Restore Validate" for oracle?

• Abhishek-422458

  SSC Journeyman

  Points: 84

  More actions

  July 5, 2007 at 1:30 am

  #117638

  Hi,

  want to know that do SQL has any feature which can do following stuff.

  when i take backup of SQL DB and i just want to check that whether that backup is done proper so that i can restore it.

  so i need functionality which tells that i can restore the backup data. Just like "Restore Validate" in Oracle.

  So does anyone has any idea about this.

  Thanx in Advance.

  -Abhishek.

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 5, 2007 at 2:00 am

  #717291

  You have the option RESTORE VERIFYONLY that can validate the backup taken.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• Deepak-405225

  SSCertifiable

  Points: 6120

  More actions

  July 5, 2007 at 2:41 am

  #717300

  hi pls refer the below link in addition to what sugesh said,

  http://msdn2.microsoft.com/en-us/library/ms188902.aspx

   

  [font="Verdana"]- Deepak[/font]