Restoring MS SQL Transaction log to mirror server
I need to restore a transaction log from one MS SQL server to a 2nd MS SQL server that is being set up as mirror server to the 1st SQL Server. How do I accomplish this action. I looked for an option within the NetBackup client on both the primary and mirror SQL servers that would allow me to restore the necessary transaction log file from the primary server to the mirror SQL server but I did not see that option available.
According to the DBAs they need the transaction logs to complete the setup of the mirroring of the database between servers.
My environment is as follows:
Windows 2008 R2 SP1 Datacenter for Master server host OS
NetBackup 220.127.116.11 Master Server
Master Server Policy has MS SQL transaction log backups every hour
Master Server Policy has MS SQL Full backups every night.
Client MS SQL server are running Windows 2008 R2 SP1 Enterprise with NetBackup 18.104.22.168 client software
The primary MS SQL server is in production at the present time and we did not want to overwrite production files inadvertently.
I looked at the following articles but did not find a solution that worked.
http://www.symantec.com/connect/forums/netbackup-75-v-ray-technology-sql-vms-and-transaction-logs - V-Ray currently not utilized for these MS SQL servers as they were originally backed up with version 6.5.6 when the policy was created for the servers.
http://www.symantec.com/connect/articles/how-backup-and-restore-microsoft-sql-server-backup-netbackup - this article seemed to be the closest to what we are trying to accomplish but we couldn't get it to work.