DBDigger is SQL Server blog of Atif Shehzad. Atif compiles his SQL Server Administration knowledge base for his own use and also to share with SQL Server online community. Atif Shehzad tends to be a helpful, active and beneficial member of SQL Server DBA community.

Thursday, March 24, 2011

A database in suspect state restricts access to data or settings. Data in suspect databases can not be pulled out nor you can perform recovery operations. In such cases, no matter the problem is due to any corrupt data page or log file, recovery is a night mare. SQL Server 2005 has introduced a very useful state for working with suspect databases. You can set the suspect database to emergency state and then exploit the wide range of operations on data and settings.

Click here to read full article with practical examples about using the Emergency State for a Corrupt SQL Server Database.

1 comment:

Thanks for sharing the recovery guide. I would like also to suggest you a third party utility, with the help of this software we can recover your data in few minutes. Website offering free version also. visit the urls to get more information.