Then I stop the sql server service, and tried to rename the. After that it worked normally, but I need the data from the corrupted mdf file, I tried to attach the database but it just hanged. I even tried to attach without the. First off, I don't think I've posted those steps. I've probably posted similar for use in DIRE circumstances like this one where there is no backup, and data loss is acceptable. Attaching the database should not hang the system.
It could make it busy for awhile, but not totally hang. You need to get the database attached to an instance in order to do anything with it. Your best bet is to put the files back in their original locations and just let it run its course. You might try putting the database in emergency mode using the steps above before putting the files back in place.
Then the database wouldn't run recovery when the instance started up. MrG MrG 65 9 9 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.
Learn More ». Get answers from your peers along with millions of IT pros who visit Spiceworks. I am trying to restore a BAK file to a different database file on the same server.
LDF]' But I get the following error. Any suggestions? Best Answer. Thai Pepper. DanaR This person is a verified professional. Verify your account to enable IT peers to see that you are a professional. Are you running Q. View this "Best Answer" in the replies below ». One common situation where you would use this method is for restoring a database from a backup file recovered from tape or one that has been copied from another machine.
The procedure for restoring from on-demand backups describes restoring from a full database backup without transaction logs. If you have restored to an existing database, test the functionality of your Workgroups application s to ensure that everything is functioning as expected.
0コメント