Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Iíve corrupt DB and I'm trying to restore its .BAK file to a DB.

28 Nov 2014   #1
emfesta73

xp 32bit
 
 
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..


My System SpecsSystem Spec
.
29 Nov 2014   #2
Alejandro85

Windows 7 Ultimate x64
 
 

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.
My System SpecsSystem Spec
02 Dec 2014   #3
nyroin46

xp 32bit
 
 

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/Fo...forum=sqltools
My System SpecsSystem Spec
.

Reply

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




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
system restore to fix corrupt files?
do you think I can use system restore to go back to the point before I used driver cleaner.net to fix my scf /scannow corrupted ati files? as of now, the system restore point I can use is not far enough to fix . every time I use the system restore, will it make a better restore date?
Performance & Maintenance
Windows Shell Common Dll Restore file type association restore.
Hi, I have been quite playing with some file with an unknown extensions like .ctp for a cakePhp file. Then I accidentally choose to open it using shell32.dll, so after that whenever i try to open the file it giving me an error. how can i restore the default association type of the file which is...
General Discussion
Corrupt system files after image restore
This has been driving me crazy, I hope someone can help! In updating to a larger system disk on Lenovo T400, I restored from an Acronis image backup. All appeared normal, including applications, except Win 7 did not recognize the signatures on its services, such as Task Manager ("do you want to...
Backup and Restore
Corrupt File
After start up, I get a wmpshare.exe is corrupt. How do I fix this file. Thanks for the help.
General Discussion


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 10:53.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App