Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-16 : 07:20:09
|
| Mitchel writes "I have a very old backup of the database and the most recent LDF log file. The main MDF file is lost. Is it possibe to recovery the database from the old backup then apply the data from the LDF file? " |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-16 : 07:36:26
|
| If your database recovery Model is FULL and there were no intervening TLog backups between your full backup and now (or you also have all the intervening TLog backups too) then you may be able to:1) Take one final TLog backups2) Restore FULL backup (preferably to a separate, new, database so as not to overwrite the original)3) Restore intervening TLog backups if any4) Restore final TLog backupIF you had Recovery Model = FULL and the absence of your MDF file makes it difficult to backup the TLog file you may be able to achieve that by:1) Restore last full backup to a NEW database2) Stop SQL server3) Copy the LDF file to be rescued to overwrite the newly restored databases LDF file4) Attempt TLog backup from new database5) Drop the new database (it is unlikely to be safe to use)There are also 3rd party Log Readers which may enable you to extract data changes from the Log FileKristen |
 |
|
|
|
|
|
SQl recovery