MS SQL Server crashed. Need in recovery

  1. profile image56
    alainmarion85posted 2 years ago

    MS SQL Server crashed. Need in recovery

    My SQL 2000 SP4 base was damaged after raid crash. Now it is marked Suspend. The backup is also not done unfortunately. And now it is possible to restore base?

  2. profile image55
    GervaseParrishposted 2 years ago

    You can read the recommendations in this forum.
    http://www.filerepairforum.com/forum/mi … r-database
    You can take the following actions:
    First of all make a backup copy of this base. I had this problem too and helped me the following:
    Turn off SQL, delete the log, turn on SQL, then:
    1.
    use master
    go
    sp_configure 'allow updates', 1
    reconfigure with override
    go
    2.
    upd ate sysdatabases set status=32768 where name = 'msdb'
    go
    3.
    DBCC REBUILD_LOG('msdb', 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL\Data\msdb.ldf')
    go
    4.
    use msdb
    go
    alt er database msdb se t SINGLE_USER with rollback immediate
    go
    use msdb
    go
    DBCC CHECKDB('msdb', REPAIR_REBUILD)
    go
    5.
    use master
    go
    sp_dboption 'msdb', 'single user', 'false'
    go
    6.
    use master
    go
    sp_configure 'allow updates', 0
    reconfigure with override
    go
    In that case if this procedure won't restore base then try to restore base by means of the utility of Recovery Toolbox for SQL Server. Sometimes happens that when no ways help to restore base and this utility helps out. You can try.   https://sql.recoverytoolbox.com/

    1. profile image56
      alainmarion85posted 2 years agoin reply to this

      Done already!    
      Thanks for the help!

 
working