|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.|
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 rellacomb6 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 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...
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 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...
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.