Restore MS SQL transaktion logs to new database
Hi!
We have recently started tests with Netbackup on SQL-servers as a way of both saving space and having a more versatile backup-environment, both for our DBAs and our backup team.
My big problem is trying to restore a database with multiple transactionlogbackups to a different name, as I quite often need to compare data from various dates and times. I have been successfull restoring with the MOVE-template, but when I try to restore subsequent transactionlog-images, it just failes .
This is the last entries from a log where I first restored the database to a different name with the move-template, and then (in the same script-file) tried to restore 3 transactionlog images.
INF - Results of executing <C:\Temp\SbManageme.bch>:
<1> operations succeeded. <3> operations failed.
INF - The following object(s) were not backed up successfully.
INF - ?
INF - ?
The database was created and is in recovering-mode, ready to receive transactionlogs, but I donĀ“t understand how I can restore them.
Is there a template available for situations like this? Where can I find that?
Thanks!