Solved I’ve corrupt DB and I'm trying to restore its .BAK file to a DB.

[emfesta73]

I’ve corrupt DB and I'm trying to restore its .BAK file to a DB.

So I have a corrupt DB in MS SQL Server 2005. I cant load it, so I cant restore to it. I created a DB with its same name. I am pulling down the most recent .BAK file for the corrupt DB, hoping it will allow me to restore it to the new DB. Is this possible or do I need to do something else? Any advice..Help..

 

[Alejandro85]

Have you tried running DBCC CHECKDB to attempt to detect errors and maybe fix them? It can be a better option if you don't want to lose data since your last backup.

Otherwise, it's simple, just delete the damaged DB and restore the previous backup files. Giving it the same name as it was before will allow client applications to run right away as they've done before.

 

[nyroin46]

hello. I had the same problem...
- Right-click the \"Databases\" folder in the Object Browser and click \"Restore Database...\" in the menu that appears.
- Select the database name (or enter the name if it does not already exist) in the \"To database\" drop-down menu.
- Select the \"From device\" option and click the button with the \"...\" symbol.
-Click the \"Add\" button and navigate to the folder on the server where the BAK file is located.
- Double-click the BAK file and then click the \"OK\" button.
- Check the \"Restore\" checkbox and click \"OK\" to restore the database from the BAK file

this site can be helpful:
https://social.msdn.microsoft.com/Forums/en-US/6562f8be-1916-491c-a69c-e8904c3b9251/sql-database-recovery-from-corrupt-database-file?forum=sqltools