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 - 2003-11-14 : 07:42:49
|
| Gerald writes "Is there a way to recover the backup history for a database andtransaction 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 recovery process began. I also have nightly db backup and transaction log backup.I have msdb and master backups and their log backups from nightlybackup.When I deleted the history, the date modified on the msdb.mdf di not change. Neither did the date modified on the msdb.ldf.Could I possibly return the backup history by restoring msdb and/or master? Another way??Please help!!!!Gerald " |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-14 : 12:05:52
|
| You don't need the backup history in order to restore or attach a database. Just run the commands in Query Analyzer:RESTORE DATABASE DBNameGoesHereFROM DISK = 'F:\MSSQL\Backup\SomeBackupFile.BAK'WITH REPLACEYou could also try to attach the database with sp_attach_db.Tara |
 |
|
|
|
|
|
backup history gone