How to restore MS SQL 2005 base?

[Former Member]

The other day I faced the damaged base of server (MS SQL 2005) which works with failure, and it is impossible to restore by testing correction (the checksum error takes off). Thus the base isn't unloaded in the file - the same mistake. Therefore it wasn't succeeded to restore base. Advise, what should I do, to save base?

[Former Member · Accepted solution]

I can advise to try to restore base by testing of the SQL. Here are the commands:

DBCC CHECKDB ('database', REPAIR_FAST)

DBCC CHECKDB ('database', REPAIR_REBUILD)

If previous two didn't help, then it is already possible to apply a third, but it carries behind it a potential data loss, and it is desirable to apply in a hopeless case.

DBCC CHECKDB ('database', REPAIR_ALLOW_DATA_LOSS)

If the command fails because there is no the single-user mode, then it is possible to pass on command

alter database db-name set SINGLE_USER

It is clear that before any tests it is necessary to make a backup copy (means of SQL if  unloading is not done).

Or also you can try to restore the database using Recovery Toolbox for SQL Server.

https://sql.recoverytoolbox.com/

[Former Member · Accepted solution]

Thank you very much for your help! I'll try to follow your advice