TechCrunch

MobileCrunch

Gizmodo

My ADSL Broadband News - Internet, Telecoms, Gaming and Computer News

Pocket-lint

Tuesday, June 22, 2010

How to Restore SQL Server 2005 Suspect Database

EXEC sp_resetstatus 'yourDBname';
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER
 
http://www.codeproject.com/KB/reporting-services/SQL_2005_Suspect_Database.aspx
 
This info me in a big way!!!! 

1 comment:

Search TechTalk

 
TwitterWind: a Twitter widget