Scheduling Database Backup Jobs
Scheduling a database backup is a simple two-step process in Teratrax
Job Scheduler. You can schedule a database backup through a simple
interface which will generate the necessary backup script.
Scheduling Database Backup
Select the information required for scheduling a database backup and
click OK to generate the necessary script to be used in scheduling the
backup:
- Database: Select the database you wish to schedule a backup
for.
- Backup File: Enter the path and file name or click on the
browse button (...) to select a physical file for your backup.
- Do not overwrite backup file: Checking this option appends
execution date and time stamp to the end of the file dynamically. This
option allows you to create backups with unique file names for
tracking backup history. If you do not check this box, the backup file
will be overwritten every time the job runs.
Click Ok to bring up the Job Details dialog with the properly formatted
SQL script text. You will need to set the schedule for the job and click
Ok to finish creating the backup job.
Remote SQL Server Backups
You can schedule a local backup on the same computer where Teratrax Job
Scheduler is installed, or a remote backup on a remote SQL Server
instance. In both cases, the path and name of the backup file are
relative to the server. If you are connecting to the local server, the
backup file will be created on the computer you are working on. If you
are connecting to a remote server, the backup file will be created on
the remote server (for example, C:\MyBackups\DB1.bkp would be created on
the C:\ drive of the remote server).
To perform a backup from one computer and leave the backup file on
another computer, you need to use mapped network drives. For example, if
you want to perform a backup of a database on computer A and leave the
backup file on computer B, then computer A has to be able to access
computer B’s hard drive via a mapped network drive (for example, X:\).
The account used by the SQL Server service must have read/write access
to the mapped drive (X:\). By default, SQL Server uses the LocalSystem
account to run its service. LocalSystem does not have read/write access
to mapped drives. You can change the Windows account used by SQL Server
from the Windows Service Manager.
Related Links
Job Scheduling
|
