Job: Logshipping Copy Transaction Logs

Job Steps:
=========
Step 1:)Delete old transaction backup
------------------------------------
del C:\WinSupport\Logshipping\transaction\*.* /Q


Step 2:)Backup Log:
--------------------
BACKUP LOG bam TO logshipping_bam_transaction WITH INIT, NO_TRUNCATE

WAITFOR DELAY '00:00:05'



Step 3:)Copy to Uitwijk:
-----------------------
xcopy C:\WinSupport\Logshipping\transaction\*.* \\srvsql-2\c$\winsupport\logshipping\transaction\ /c /Y



Step 4:)Copy to Standby:
------------------------
echo xcopy C:\WinSupport\Logshipping\transaction\*.* \\psqlweb4\c$\winsupport\logshipping\transaction\ /c /Y



Step 5:)Apply on both:
--------------------
EXEC [srvsql-2].master.dbo.restore_log_backups
--EXEC [psqlweb4].master.dbo.restore_log_backups




Step 6:)Dummy (Op master):
-------------------------
sp_who