Backup file

• subbarayudu.net 37258

  Mr or Mrs. 500

  Points: 540

  More actions

  August 9, 2010 at 6:52 am

  #227614

  Hi all,

  I take the Back-up file, back-up file contains all procedurea,functions,tables,views,jobs and login permissiopns remaining all are there what ever in the main database.

  so how to Know all are there or not.

  for verification purpose regarding prosedure,triggers,functions,jobs ans views how to vaerify in the bak file.

  We take the backup file from existing database. but inside the backup file we don't know what is there. how to know the inside backeup file information.

  please help me.

  Subbarayudu k

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  August 9, 2010 at 7:05 am

  #1204138

  there is no SQL command to prove a backup is complete, but why should it not be?

  you can use restore verifyonly to prove it is a valid backup set.

  the backup command does have the checksum option (see BOL)

  Only 100% true test is to restore the database somewhere and check it.

  ---------------------------------------------------------------------