Backing Up SQL Server

You can manage SQL Server instances and database backups, including both full and incremental backups, using the SQL Server Backup option for SQL Server running on a Windows server.

To set up SQL Server backup:

1. Right-click the CTERA Agent tray icon, , and select Settings.
2. The CTERA Agent Settings window is displayed.
3. Select Backup Options > SQL Server Backup.
   The SQL Server Backup window is displayed, listing all the SQL Server databases.
   

4. Click Settings to select the databases and instances to backup.
   The Select Databases to Backup window is displayed.
   
5. Check the databases to be backed up and click Save.
   Note: The selected databases are marked with .
6. Click Schedule to create a backup schedule.
   
   Schedule backup:
   Periodically – Specify the length of time between starting each full backup in either minutes or hours.
   Start Every – The amount of time, minutes or hours, between each full backup.
   Note: If the backup continues passed the time of the next scheduled backup, the next backup does not run. It is recommended to schedule a full backup not more than once every 24 hours and use the transaction log to back up incremental changes.
   Specific Time – Specify a fixed time to start the backup each day and either an end time or let the backup run to completion.
   Start Time – The time to start the full backup.
   Stop Time – The time to stop the backup, whether it has completed or not, or to stop on completion.
   On Days – The days to run the full backup.
   Note: It is recommended to schedule a full backup not more than once every 24 hours and use the transaction log to back up incremental changes.
   If a Windows Server has Microsoft SQL Server installed, you can schedule the recovery point objective (RPO) for SQL Server:
   Transaction Log Backup – In addition to running a full backup, you can check Transaction Log Backup , in which case the delta changes are written to a transaction log, enabling the database or instance to be restored to a specific point in time when a transaction log exists.
   Start Every – The amount of time, minutes or hours, between each delta backup.
7. Click Save.

The backup is scheduled.

Testing SQL Server Connectivity

You can test the connectivity to the SQL Server.

To test connectivity:

1. Right-click the CTERA Agent tray icon and click Settings.
2. Select Backup Options > SQL Server Backup.
   The SQL Server Backup window is displayed, listing all the SQL Server databases.
   
3. Click Test Connectivity.
   The Test Connectivity window is displayed.
   The results of the connectivity test are displayed.
4. Click Close to end the test.