Question Locked

How to repair a 'Suspect' MS SQL (2008) database

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

My database has gone offline, it is highlighted as 'Suspect'.

I haven't a recent back up of my database.

Is there a way of quickly restoring the database?

Thank you!

7 replies

by merrillc.solis

Use SQL database recovery software because this tool is a relevant solution to recover damaged SQL MDF & NDF file and doesn’t make any kind of changes to SQL database, while repairing them it also recover all components like tables, functions, stored procedures, views, constraints, triggers and more.

Read more: http://www.pcrecoverytools.com/sql-database-recovery.html

by wiktor.lissowski

you can follow the instructions below for the version of SQL Server running on your server.

SQL:

1. Log onto SQL Server Management Studio.
2. Navigate to the database you wish to restore.
3. Right Click > Tasks > Restore > Database.
4. Once on the General tab set the source to Device > Select Backup Device > Add > Navigate to the .bak file you're restoring to.
5. Ensure The Destination Database is the correct one.
6. Select the Options tab.
7. Check "Overwrite the existing database (WITH REPLACE)" and "Close existing connections to destination database".
8. Uncheck "Take tail-log backup before restore".
9. Click OK.

Apply third party software solution SQL Server Repair Toolbox

Visit following page for more useful info:-

http://www.sqlserver.repairtoolbox.com/

More info you would find out on

http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/1492-sql-database-corruption-on-sql-2014

by kimsharma615

Use Kernel for SQL Database Recovery Software and solve all types of database issues in few steps. Software support multiple MDF file and full support to recover triggers, keys, indexes and stored procedures. Software is supported by all SQL Server version.
Get more ideas and download free trial version from - http://www.sqlrepair.org/

by michaeleesparza

It can easily repair and restore MDF file with its element tables, triggers, views, store procedure, XML data types & user define data without facing any problem. This is great software to repair data of corrupted SQL MDF file of the SQL Server database. The software recovers SQL Server 2012, 2008 / 2008 R2, 2005 and 2000 database files.

To download:- http://www.filesrecoverytool.com/sql-database-repair.html

This discussion is closed to new replies.