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 Research Analyst 10 years ago
What are the best Oracle Database Archiving Solutions ?
by eskilddam 4 years ago
How open content corrupt illustrator file?I know what the answer will probably be to this. But as I was saving something in photoshop, I went to save something in illustrator that I had traced from an image I had just dragged from the net and it crashed on me and ive just lost two hours of work. I...
by Muhammad Junaid 6 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 rellacomb 19 months ago
by edmonddidier 3 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 ibanga007 11 years ago
How To Restore Hal.dll From the Windows XP CDThe hal.dll file is a hidden file that is used by Windows XP to communicate with your computer's hardware. Hal.dll can become damaged, corrupted or deleted for a number of reasons and is usually brought to your attention by the "missing or corrupt...
Copyright © 2019 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.
HubPages Inc, a part of Maven Inc.
|HubPages Device ID||This is used to identify particular browsers or devices when the access the service, and is used for security reasons.|
|Login||This is necessary to sign in to the HubPages Service.|
|HubPages Traffic Pixel||This is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.|
|Remarketing Pixels||We may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.|
|Conversion Tracking Pixels||We may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.|