How to restore database MSSQL 2005 SP4?

[alainmarion85]

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?

 

[DelJo63]

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

 

[GervaseParrish]

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]

Thanks for the feedback! The problem was solved.

 

[DelJo63]

Thanks for the feedback! The problem was solved.

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