SQL Server Window: selecting SQL Servers for database backups
The SQL Servers window is where you can configure Microsoft SQL Server database backups. BackupAssist can authenticate to SQL servers using either Windows or SQL authentication. To perform transaction log backups of your SQL databases, you need to create a job using the SQL Method.
Creating additional backup jobs
Choosing a backup method
The database backup works by logging into your SQL Server and performing a database backup to files (with .bak extension). These SQL backup files are then transferred to your backup device (tape, hard drive, network server, etc.) This design gives you maximum flexibility when you need to do a restoration, because your SQL Server does not need access to your tape drive (or other backup device).
- Note: if you are running a File Replication, Zip, Rsync or Windows Imaging job you can also backup your entire SQL Server by performing a VSS application backup. There are, however, many advantages to using the SQL Add-on including: remote SQL database backup; transactional log backups for near-continuous data protection; point-in-time restore using the SQL Restore utility; and portable SQL backup files in .BAK format that can be easily moved to any server.
Selecting VSS applications for backup
SQL Add-on whitepaper
To access the SQL server Window :
- Click
Jobs in the navigation bar - Right-click on the desired job and select Edit.
- Click
SQL server on the left menu.
MSSQL server selection
Add one or more SQL servers for backup to your backup device. The backup of each SQL server can be configured separately to include individual SQL databases or all databases on that server.
SQL directory options *
Specify the directory where SQL backup files (with .bak extension) will be stored before being transferred to the specified backup device.
