Page History
...
Access Filesystem As
This is the account SQLsafe SQL Safe will use to access the specified primary and mirror locations. Depending whether you selected to use the SQL Server Agent or the SQLsafe SQL Safe Backup Agent for the scheduling of your log policy, on this section you have the option to select between SQL Server Agent service account/SQLsafe SQL Safe Backup Agent service account respectively or a Windows account. Click Account and select your preferred option.
...
You can also choose how to handle errors encountered while writing to the network during a backup by selecting Enable network resiliency. By default, SQLsafe SQL Safe will retry the backup operation every 10 seconds and then fail after 5 minutes (300 seconds) of continuous errors. Also, over the course of the operation, SQLsafe SQL Safe allows a total of 60 minutes in which to retry the backup before stopping the operation.
...
This is the first location where the backup files will be stored. By default, SQLsafe SQL Safe will ship the backup files from this location to your secondary server. When you configure the secondary database settings , you can specify an alternate location.
Enter the network path or click Browse to select the location of where you want the log backup archive to be kept. The destination folder must be configured as a network share.
| Info |
|---|
SQLsafe SQL Safe detects if the Computer Browser service is not running on your computer. This service enables Windows to list other computers on the network, if this service is not running, Windows may not be able to list the computers on your network. SQLsafe SQL Safe allows you to start this service but keep in mind that it may take several minutes for computers to become visible. |
You can also specify how long you want to keep old backup files. By default, SQLsafe SQL Safe will delete files older than three (3) days.
...
These are the locations where copies, or "mirrors", of the backup files will be saved. For each mirror location, SQLsafe SQL Safe creates and stores a copy of the backup files. You can specify up to 2 mirrors for each log shipping operation. Keep in mind that creating mirrors can impact the performance of your log shipping operation.
...
- How long you want to keep old backup files. By default, SQLsafe SQL Safe delete files older than three (3) days
- Whether SQLsafe SQL Safe should cancel the backup when one of the specified mirror locations reports a failure, such as connection timeout.
...
Select Retry writing backup files after network errors, and then click Configure to change the default settings. By default, SQLsafe SQL Safe will retry the backup operation every 10 seconds and then fail after 5 minutes (300 seconds) of continuous errors. Also, over the course of the operation, SQLsafe SQL Safe allows a total of 60 minutes in which to retry the backup before stopping the operation.
This option is not available when backing up to tape using Tivoli Storage Manager.
SQL
...