After the virtual machine backup schedule is created, you can create the Microsoft SQL Server log backup schedule.
About this task
Backing up SQL server logs provides a more granular level of recovery points. You might
find it unnecessary to back up SQL server logs if the frequency of your backups provides you with
enough recovery points, and assuming that you did not specify the INCLUDE.VMTSMVSS
vm_display_name OPTions=KEEPSqllog option for the backup.
Procedure
-
Start the Data Protection for Microsoft SQL Server user interface
from the virtual machine that is hosting Microsoft SQL
Server.
-
In the navigation pane, expand the Manage node.
-
Under the Manage node, right-click .
- Open the Scheduling Wizard to identify
the schedule name and time.
-
For the Define the Scheduled Task page, select Command
Line.
-
Click the icon to select the SQL Server template. Click Next.
-
Use the command-line interface and SQL Server template to specify the database log backup, for
example:
tdpsqlc backup * log /truncate=yes 2>&1
Tip: Alternatively, you can schedule Microsoft SQL Server backups by using the IBM Storage Protect centralized scheduling service. This service helps
you to create a backup schedule for all Microsoft SQL
Server instances on a virtual machine.