Suspected Database

  • Comments posted to this topic are about the item Suspected Database

  • Not sure what you are referring to in step 2:

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

    Nancy

  • 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

  • Thanks, didn't catch the SQL 2000 part.

    Nancy

  • 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

  • Thanks for the script.

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

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