Naming a task in C#

Painting USS Code 128 in C# Naming a task

Enter a Windows account that has at least db_backupoperator role privileges for all of the databases (see figure 4). After creating the scheduled task, open the properties of the job you just created. On the Schedule tab, click the Advanced button. On the Advanced Schedule Options window (figure 5), click the Repeat Task check box. Enter the values as defined by your log backup frequency, in this case 15 minutes, and specify a duration of 24 hours. Now that we have created the automated job to generate the log backups, we need to share the folder that will contain the log backups. We ll share the E:\LogShipFolder in this scenario in case you plan to create log shipping jobs for more than one database on this instance. This should be accessible from the standby server, either via the IP address or the DNS name. On the standby server, copy the robocopy.exe file into the E:\LogShipFolder\scripts folder. Then create a batch file that will call the robocopy.exe utility, passing the corresponding parameters. This batch file will copy the log backups from the primary server to the standby server and should be run in the standby server. Let s call the batch file logShipRobocopy.cmd and save it in the same folder. We add another line on the batch file to call a VBScript file that will be responsible for restoring the log backups on the standby server based on time stamps. The batch file will contain the commands shown in listing 4.

REM ROBOCOPY job to copy the transaction log backups from the primary REM server to the standby server ROBOCOPY \\primary-server\LogShipFolder E:\LogShipfolder /COPY:DATSO /MIR REM Call the VBScript file that will run a RESTORE LOG command REM The VBScript file accepts 2 parameters the folder containing the REM transaction log backups and the database name E:\LogShipFolder\scripts\restoreLOG.vbs E:\LogShipFolder\ Northwind

The /COPY option, in the ROBOCOPY command, with the corresponding flags copies the files together with the file information as specified by the following switches:

D File data A File attributes T File timestamps O File ownership information U File auditing information S File security (NTFS ACLs)

Both source and destination volumes must be formatted using NTFS to allow copying of Security, Ownership, and Auditing information. If this switch is omitted, the default is /COPY:DAT, or /COPY:DATS if /SEC is specified. The /MIR (short for mirror) switch is used to maintain an exact mirror of the source directory tree. This ensures that whatever the users did on their machines is replicated on the server. The restoreLOG.vbs file will contain the commands shown in listing 5.

'This script does a custom log shipping job using ROBOCOPY and VBScript 'with FileSystemObject querying the specified folder for files created 'within the past 15 minutes or less and generates a TSQL RESTORE LOG 'command which is executed after the ROBOCOPY script 'Syntax: restoreLOG.vbs folder databaseName On Error Resume Next Dim sFolder, sFolderTarget, strParentFolder, strDatabaseName Dim fso, folder, files, strFileNameResults, objShell Set fso = CreateObject("Scripting.FileSystemObject") Set objFSO = CreateObject("Scripting.FileSystemObject") strParentFolder=Wscript.Arguments.Item(0) strDatabaseName=Wscript.Arguments.Item(1) sFolder = strParentFolder & strDatabaseName Set folder = fso.GetFolder(sFolder) Set files = folder.Files SET objShell = CreateObject("Wscript.Shell") For each itemFiles In files

a=sFolder & "\" & itemFiles.Name 'retrieve file extension b = fso.GetExtensionName(a) 'check if the file extension is TRN If uCase(b)="TRN" Then 'check for DateCreated attribute of file and compare with current 'date/time If (DateDiff("N", itemFiles.DateCreated, Now) <=15) Then 'Create the file to contain the script If (objFSO.FileExists("E:\LogShipFolder\scripts\SQL\" & strDatabaseName & ".sql")) Then objFSO.DeleteFile ("E:\LogShipFolder\scripts\SQL\" & strDatabaseName & ".sql") End If Set objMyFile =

objFSO.CreateTextFile("E:\LogShipFolder\scripts\SQL\" & ".sql", True)

str1="RESTORE LOG " & strDatabaseName str2="FROM DISK='" & a & "'" str3="WITH STANDBY='E:\LogShipFolder\UNDO\UNDO_" & strDatabaseName & "_ARCHIVE.DAT'," str4="DBO_ONLY" objMyFile.WriteLine objMyFile.WriteLine objMyFile.WriteLine objMyFile.WriteLine (str1) (str2) (str3) (str4)

objMyFile.Close Set objFSO = Nothing Set objMyFile = Nothing 'Run an OSQL command that uses a RESTORE LOG WITH MOVE,