How to to check status of Restore

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

How to to check status of Restore

Author

Topic

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2007-10-01 : 07:15:03

Hi Guys,
I have restored one database in sql server 2000 last week.
Could you tell me how to check that , my restore was succesful.

SQL IN Minds

Kristen
Test

22859 Posts

Posted - 2007-10-01 : 07:54:20

How do you mean by "successful"?

You can check the "health" of your database using:

DBCC CHECKDB('MyDatabaseName') WITH NO_INFOMSGS

and you can check the History of database restores in MSDB

See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources