Home Forums SQL Server 7,2000 Backups Backup/Restores for Database Mirroring Session RE: Backup/Restores for Database Mirroring Session

  • Hi, thanks for the reply, the database am using has a job that backs up the transaction log every day, so I guess there will be loads of log files.

    What I did was take the full backup, restored it with "no recovery" then a transaction log backup after that and restored only that transaction log backup. Am doing it as a test not production, would I have to restore all the previous log backup ( there are many of them and from what date).