|
DIY Online Backup can perform
scheduled backup of Microsoft SQL Databases, these have Priority over other
packs, so they are always performed before backing up files. Therefore
the backup files can be included in part of another backup operation.
The Microsoft SQL Databases can
be backup while running.
To create a Microsoft SQL
Databases backup
Simply press [Add Job]
button. Then enter a name for the backup job and description which will help you distinguish
Microsoft SQL Database backups. Then enter Microsoft SQL Server name,
Microsoft SQL Database name, Microsoft SQL User name and
password who has the right to perform a Microsoft SQL
backup. Use the [Test Connection] button to test the validity of
the SQL settings.
Next select the SQL Backup type,
this can be either Full, Log, or Differential depending on the type of
Microsoft SQL database you are running. You should probably
schedule a "Full" backup once a week followed by "Logs"
or "Differential " every day. You must set different
backups for the different types, but you can use the [Create copy] button to
create a duplicate and then simply edit the settings.
Finally Select the destination of
the backup and set its filename. Note this is the physical folder to
write a backup too, not a DIY Online Backup Storage folder, it must be local
(Mapped path or UNC network path) to the SQL server. You must setup
another file backup to transfer the Microsoft SQL database to storage
folder. Then enter the filename of Microsoft SQL
backup. By default it is "BackupDATE", DIY Online Backup
will replace "DATE" with the date of backup when run. So you
will end up with files, Backup_200606007.bak, Backup_200606008.bak, etc.
Main options
Job Name - Name of Job,
cannot be altered once set.
On Hold - Simply allows you to suspend the job, under "On hold"
is un-ticked
Schedule - Allows you to set the start, end and days the backup should
run. These predefined backups schedules can be edited under the
"settings" tab on the main window.
Description - Is for you
to enter long description to help identify the function of this
Microsoft SQL database backup setting.
Server - Name of
Microsoft SQL database server
Database - Microsoft
SQL database
User - Microsoft SQL
database username who has rights to backup
Password - Microsoft
SQL database password for username
Backup type - Full, Log,
or Differential depending on the type of Microsoft SQL database you
are running
Backup To - The physical
folder to store the Microsoft SQL database archive/backup. It
must be local (Mapped path or UNC network path) to the Microsoft SQL server.
Backup Name - The filename
of Microsoft SQL backup. By default it is
"BackupDATE", DIY Online Backup will replace "DATE" with
the date of backup when run. So you will end up with files,
Backup_200606007.bak, Backup_200606008.bak, etc.
Logs
Each backup job is logged, and
under this tab you can view the history of backup jobs. The days the
system should keep these logs are defined in system settings.
|
