Suspected Database

  • Yousaf Khan

    Ten Centuries

    Points: 1147

    Comments posted to this topic are about the item Suspected Database

  • nancy.lytle

    Default port

    Points: 1430

    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: 4431

    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

    Thanks, didn't catch the SQL 2000 part.

    Nancy

  • naresh_ee

    SSC Veteran

    Points: 288

    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

    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