Is there a way to recover the backup history for a database and
transaction log? I inadvertently deleted the backup history while trying
to restore and recover in a Full Recovery model. I need to do a
"point-in-time" restore of the log.
I still have copies of the mdf and ldf as they were before the process
began. I also have nightly backup and transaction log backup.
I have msdb and master backups and their log backups from nightly
backup.
When I deleted the history, the date modified on the msdb.mdf changed.
Neither did the date modified on the msdb.ldf.
Could I possibly return the backup history by restoring msdb and/or
master?
Please help!!!!
Gerald
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!If you have the full DB and the tran logs, and they are
appropriately labelled, you shouldn't have to need the
backup history. Just apply them in the right order and
you should be fine - remember to use STANDBY or NORECOVERY
until the last log file.
>--Original Message--
>Is there a way to recover the backup history for a
database and
>transaction log? I inadvertently deleted the backup
history while trying
>to restore and recover in a Full Recovery model. I need
to do a
>"point-in-time" restore of the log.
>I still have copies of the mdf and ldf as they were
before the process
>began. I also have nightly backup and transaction log
backup.
>I have msdb and master backups and their log backups from
nightly
>backup.
>When I deleted the history, the date modified on the
msdb.mdf changed.
>Neither did the date modified on the msdb.ldf.
>Could I possibly return the backup history by restoring
msdb and/or
>master?
>
>Please help!!!!
>Gerald
>
>*** Sent via Developersdex http://www.developersdex.com
***
>Don't just participate in USENET...get rewarded for it!
>.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment