SQL database is crashed
Our server was hit by some unknown virus which seems to have corrupted header information for many of our files including an important databases and some of its backups. However the log file (.LDF) for the live DB was not affected. We also have a relatively old .BAK backup file.
Is it possible to bring the DB (.MDF) in the old backup to Live standard using the new/latest Log file? If so, how? Any help is truly appreciated.
Follow the steps mentioned below:
* Take a tail log backup of your database after your full backup
* Restore your Full backup available with you using WITH NORECOVERY option.
* Restore Differential backups ( if you have in order) WITH NORECOVERY option
* Restore Transactional log backup in order WITH NORECOVERY and the last tail backup taken using WITH RECOVERY option..
Also have a look this Recommended actions
But how do I "Take a tail log backup of your database after your full backup", since I don't have access to the original DB anymore.
Ok, If your database is not functional now, then you can't take tail log backup.
In that case, try the steps given below:
* Detach your database
* Copy your LDF File to a new location
* Attach MDF File without providing LDF file.
Test whether this
You've been very kind in your efforts to help. Thanks for that. Solved!
by pasterrichard052 years ago
What do mysql backup and restore ?I am newbie to mysql and want to clarify below on mysql backup and restoreWhat are the things needed to backup mysql and restore it like database name, username, password etc.1)I have a...
by rellacomb5 months ago
How to unlock the password of my itunes backup file?I need to restore from my existing itunes backup file because I deleted important photos on my iPhone. Actually, I backed up the phone a week ago but just forgot the...
by Research Analyst8 years ago
What are the best Oracle Database Archiving Solutions ?
by Muhammad Junaid5 years ago
My WordPress is hacked what should I do?Hi I was hosting my site for about 6 months but today I watched that was being hacked by some one and I don't have backup also
by igilstua2 years ago
Access - Corruption in this file. Is the MDB file lost?I recently tried to to compact an Access DB and got the following message: " has detected corruption in this file. To try to repair the...
by edmonddidier2 years ago
Word2010 saved file to desktop not foundWord 2010 extensive and complicated document saved to desktop many times throughout the day. After reloading Word and opening the file, it is an older version of the file...
Copyright © 2018 HubPages Inc. and respective owners.
Other product and company names shown may be trademarks of their respective owners.
HubPages® is a registered Service Mark of HubPages, Inc.
HubPages and Hubbers (authors) may earn revenue on this page based on affiliate relationships and advertisements with partners including Amazon, Google, and others.