Forum Discussion

sbj's avatar
sbj
Level 1
5 years ago

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!

 

 

  • Hello,
    You must edit move template script for all transaction log restores, too. Have you done this?
    Regards
    Michal