Restore Database - Is Fully Restored or Not

  • Hi,

    I have done Restore database in Sql Server 2005. Can Any one help me How can I check whether my Database Restored Completely or not. Is there any script to run and check that.

  • That depends on your definition of "Restored Completely". If you can access the database (period), then your database is recovered. Could you give us some details on the problem or question you have in your scenario happening right now?

    In what way would someone walking up to your desk (not knowing anything about your database) suspect it wasn't completely recovered? Do you have some reports that show incorrect data or something? When you query the database does SQL return an error saying that "...database xxx is in the middle of a restore"?

    Thanks!

    MJM

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

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