Thursday, March 24, 2011

Emergency State for recovery of Corrupt SQL Server Database

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:

  1. 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.

    http://www.recoverydeletedfiles.com/sql-database-recovery-software.html


    Thanks

    ReplyDelete

Any Comments: