Suspected Database

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

nancy.lytle Default port Points: 1430 More actions · Answer 1

Not sure what you are referring to in step 2:

--2. Stop MSSQLSERVER service, replace created mdf file with original one

Nancy

2 Tim 3:16 SSCarpal Tunnel Points: 4541 More actions · Answer 2

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

nancy.lytle Default port Points: 1430 More actions · Answer 3

Default port

Points: 1430

July 23, 2009 at 11:25 am

Thanks, didn't catch the SQL 2000 part.

Nancy

naresh_ee SSC Veteran Points: 288 More actions · Answer 4

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 5

SSC Guru

Points: 76202

May 24, 2016 at 7:05 am

Thanks for the script.