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 rellacomb 10 months ago
by Research Analyst 9 years ago
What are the best Oracle Database Archiving Solutions ?
by edmonddidier 2 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 saved early in the day. What can be done to find it? They have tried...
by pasterrichard05 3 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 database which need to be restored on different server so I used mysql dump...
by alainmarion85 3 years ago
MS SQL Server crashed. Need in recoveryMy SQL 2000 SP4 base was damaged after raid crash. Now it is marked Suspend. The backup is also not done unfortunately. And now it is possible to restore base?
by igilstua 2 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 corruption, first make a backup copy of the file. Then, on the tools menu,...
|HubPages Device ID|
|Login||This is necessary to sign in to the HubPages Service.|
|HubPages Google Analytics|
|HubPages Traffic Pixel|
|Google Hosted Libraries|
|Google AdSense Host API|
|Conversion Tracking Pixels|
|Author Google Analytics|
|Amazon Tracking Pixel|