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

Backup Databases to another Disck

SET NOCOUNT ON
DECLARE @dbs_nam AS varchar(50) -- Database naam
DECLARE @opd AS varchar(2048) -- Opdracht
-- Creëer cursus met select statement voor welke databases gedumpt moeten worden
DECLARE dmp_dbs_cur CURSOR FOR
SELECT [name]
FROM [master].[dbo].[sysdatabases]
WHERE [dbid] <> 2
-- Open cursor
OPEN dmp_dbs_cur
-- Pak de volgende uit de resultset van de cursor en plaats deze in de variabele @dbs_nam
FETCH NEXT
FROM dmp_dbs_cur
INTO @dbs_nam
-- Voer de volgende serie acties uit zolang de resultset nog niet geheel doorlopen is
WHILE @@FETCH_STATUS = 0
BEGIN
SET @opd = 'BACKUP DATABASE [' + @dbs_nam + ']
TO DISK = N''\\psms2\Install\Back-up\' + RTRIM(CONVERT(varchar(64), SERVERPROPERTY('servername'))) + '\20070903_1045uur_' + @dbs_nam + '.BAK'' WITH NOFORMAT
, NOINIT
, NAME = N''' + @dbs_nam + '-Full Database Backup''
, SKIP
, NOREWIND
, NOUNLOAD
, STATS = 10'
PRINT @opd
EXEC (@opd)
FETCH NEXT
FROM dmp_dbs_cur
INTO @dbs_nam
END
-- Sluit de cursor
CLOSE dmp_dbs_cur
-- Geeft geheugenruimte weer vrij
DEALLOCATE dmp_dbs_cur