How to restore database MSSQL 2005 SP4? 2

[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?

 

[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).
In that case, if this way cannot restore a database, then use the Recovery Toolbox for SQL Server. It often helped out me.

https://sql.recoverytoolbox.com/

It is possible to found additional councils and recommendations on this resource

http://www.filerepairforum.com/foru...l-server/1914-restore-the-sql-server-database

 

[alainmarion85]

Thank you!