TechSpot

How to restore database MSSQL 2005 SP4?

By alainmarion85
Jul 20, 2015
Post New Reply
  1. How to restore base after RAID crash? I hoped to restore using Backup, but very late noticed that the Backup was not done. Now how do I restore the database on MSSQL 2005 SP4, which is marked with Suspend?
     
  2. jobeard

    jobeard TS Ambassador Posts: 9,311   +617

    Does your Raid enclosure support HOT-SWAP? I so, find out which HD failed and just insert a new one.
     
  3. GervaseParrish

    GervaseParrish TS Rookie

    Use master
    go
    sp_configure 'allow updates', 1
    go
    ---Execute---
    reconfigure with override
    ---Execute---
    select status from sysdatabases where name = 'DataBaseName'
    ---Execute---
    EXEC sp_resetstatus 'DataBaseName';
    ALTER DATABASE DataBaseName SET EMERGENCY
    ---Execute---
    alter database DataBaseName set EMERGENCY, SINGLE_USER
    ---Execute---
    dbcc checkdb ('DataBaseName', REPAIR_ALLOW_DATA_LOSS)
    ---Execute---
    alter database DataBaseName set ONLINE, MULTI_USER
    ---Execute---
    Use master
    go
    sp_configure 'allow updates', 0
    go
    ---Execute---
    reconfigure with override
    P. S. If in the end "dbcc checkdb" to swear on something that can't create log file then create the folder that it asks for and repeat the operation with this item again (if the base stood in other place earlier).
    It is possible to found additional councils and recommendations on this resource
     
    alainmarion85 likes this.
  4. alainmarion85

    alainmarion85 TS Rookie Topic Starter

    Thanks for the feedback! The problem was solved.
     
  5. jobeard

    jobeard TS Ambassador Posts: 9,311   +617

    COME COME:- HOW!!! Be a leader and show others what you did - - PLEASE !
     

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...