Post reply

What kind of verification required for database restoration

  • October 24, 2007 at 2:53 am

    #153913

    Hi,

    In the event that I require to restore the user database. What kind of verification required to ensure that the restoration is performed succesfully.

    Is it sufficient if I just ensure that all objects are restored?

    Cheers

  • October 27, 2007 at 11:57 pm

    #746036

    Before restore:

    Use Restore verifyonly to make sure you have valid backup for restoration

    Ensure no connections to be exists in the database

    Make sure you have necessary space to restore the database

    After restore:

    Check the data integrity

    Fix mismatch ID's and orphan ID's, if you perform restoration in some other server

    Regards..Vidhya Sagar
    SQL-Articles

  • October 29, 2007 at 1:22 am

    #746104

    Hi,

    Thanks for your feedback. I'll perform RESTORE VERIFYONLY (before restoration) and DBCC CHECKDB (after restoration) before I declare that the database is up to our application team.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply