Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Suspected Database Expand / Collapse
Author
Message
Posted Friday, July 17, 2009 12:20 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Saturday, August 9, 2014 11:50 PM
Points: 407, Visits: 78
Comments posted to this topic are about the item Suspected Database
Post #754638
Posted Thursday, July 23, 2009 5:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 11:12 AM
Points: 386, Visits: 410
Not sure what you are referring to in step 2:
--2. Stop MSSQLSERVER service, replace created mdf file with original one

Nancy
Post #758127
Posted Thursday, July 23, 2009 10:03 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 25, 2014 9:57 AM
Points: 1,081, Visits: 1,493
this appears to be for SQL 2000 or below. You cannot update system tables in SQL 2005 or above.

The best article on this subject is from Gail Shaw - http://www.sqlservercentral.com/articles/65804/ for SQL 2005 and above.


Tim White
Post #758393
Posted Thursday, July 23, 2009 11:25 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 11:12 AM
Points: 386, Visits: 410
Thanks, didn't catch the SQL 2000 part.

Nancy
Post #758459
Posted Saturday, April 10, 2010 4:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 9, 2011 8:33 AM
Points: 216, Visits: 43
When ever you find that the data base is in suspect mode use the below script.

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

Regards,
Adapala.N
Post #901031
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse