Reference: http://www.vnypatel.com/repair-sql-server-2008-r2-suspected-database
- Home
- About Us
- Recovery Services Individual RecoveryEnterprise RecoveryAdditional Recovery
- Software
- Testimonials
- Locations
Tuesday, 14 July 2015 00:00
- font size decrease font size
increase font size
Repair SQL Server 2008 R2 Suspected Database
Just a day before , come across new issue of database . for some reason database found in suspect mode ! and that was horrible moment.
After some search , we got brief idea that , database can go in suspect mode for many reasons like improper shutdown of the database server, corruption of the database files etc.
To find out what exactly gone wrong with database we tried following query
DBCC CHECKDB (‘YOUR_DATABASE_NAME’) WITH NO_INFOMSGS, ALL_ERRORMSGS
(It wasn’t much helpful in my case . I am just posting here in-case it hepls other !)After a while we run another block of code , to put the database in emergency mode (Ref : MSDN )
EXEC sp_resetstatus ‘YOUR_DATABASE_NAME';
ALTER DATABASE YOUR_DATABASE_NAME SET EMERGENCY
DBCC checkdb(‘YOUR_DATABASE_NAME’)
ALTER DATABASE YOUR_DATABASE_NAME SET SINGLE_USER WITH ROLLBACK
IMMEDIATE
DBCC CheckDB (‘YOUR_DABASE_NAME’, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE YOUR_DATABASE_NAME SET MULTI_USER
Finally we got database back online !
Data Recovery Expert
Viktor S., Ph.D. (Electrical/Computer Engineering), was hired by DataRecoup, the international data recovery corporation, in 2012. Promoted to Engineering Senior Manager in 2010 and then to his current position, as C.I.O. of DataRecoup, in 2014. Responsible for the management of critical, high-priority RAID data recovery cases and the application of his expert, comprehensive knowledge in database data retrieval. He is also responsible for planning and implementing SEO/SEM and other internet-based marketing strategies. Currently, Viktor S., Ph.D., is focusing on the further development and expansion of DataRecoup’s major internet marketing campaign for their already successful proprietary software application “Data Recovery for Windows” (an application which he developed).
Latest from Data Recovery Expert
Leave a comment
Make sure you enter the (*) required information where indicated. HTML code is not allowed.
Copyright © 2024 DataRecoup Recovery Services. All Rights Reserved. Designed by DataRecoup Lab.
