|
|
|
|
Step by step backup SQL Server database
General settings
Database information
Backup types
Data compression and encryption settings
Email notification
General settings
SQL Server instance : The server you want to back up.
Job name : The name of your backup job .
Source database : The database you want to back up.
Backup to : The destination directory where the backups are stored.
Local machine / Network shares .
If the destination directory is a local folder or network shared folder , please select this option , in this case , the "Remote Storage Server" (databkserver.exe) needn't to be running . If the destination directory is a network shared folder , you must have the write privilege on it , and the "Data Directory" field value should begin with "\\" .
Remote storage server .
If the destination directory is on a remote machine , please select this option .
Account setting
1. If database is backed up to a remote pc , you need to specify who can connect to the remote storage server.
2. Run the remote storage server program before backup job begins . All accounts are added in "Remote Storage Manager" program.
Database information
"Database Information" tab shows the information of selected database , including recovery modal , database files .
Select a backup type
Backup types
When is a full backup required?
When is a differential backup performed?
What is transaction log backup?
Full backup . --- Backup the entire database , include the all data files and logs .
Differential backup. --- Only backup the new added or modified data since last full backup.
Transaction log backup. --- Backup transaction log of a database.
Backup expiration settings . --- If you select this option , backups in the destination directory will be deleted after a specified number of days , This will help you save and recycle your storage spaces .
Compress and encrypt data
Compression settings
Use data compression --- If you want to compress the backed up data , just select this option.
Compression Level --- There are 10(0~9) compression options, help you generates smaller backup file. 0 means on data is compressed, 9 level has highest compression ratio and take more time to process data .
Encryption Setting
Use data encryption ---If you want to encrypt the backed up data , just select this option.
Key type --- There are 3(128 bits,192 bits,256 bits) encryption options,protect you backup file.
Encryption Key --- Input your password here , if you lost the password, you won't be able to use the backup file when restore.
Confirm --- Confirm your password
EMail Notify
Email notify -- If you select this option , you 'll receive a email after the job .
Mail server settings
Mail server --- The SMTP server that send the mail.
Port --- The port that mail server use. Most mail server use the port 25.
Require authentication --- If your mail server require authentication , please select this option.
Account --- The account that login to the mail server .
Password --- The password that use to login to mail server.
Email settings
Send To --- The mail box that receive the notification mail.
CC --- Mail box that copy this mail to.
Subject --- Subject of the notification mail . If you keep the field is "" , the subject will appear as "jobname + start date time + Job Status ". If you want to change the subject , just fill the text you want .
Sender --- The outgoing mail box .
Attached with Log file --- Log file will be created during the job running stage .it will send you as attachment of the mail if you check this box..
|
|
|
Home