You can backup and restore your SQL Server databases. The SQL Server backup and restore component provides an important safeguard for protecting critical data. Click to open an object list for SQL Server Backup.
Note: The backup file is stored in the server.
SQL Server Backup
Before starting the backup process, click Generate SQL button to review the SQL. Then, you can click the
Start button to run it. If you want to backup with the setting of an existing backup file, you can control-click a backup file
in the Object List pane and choose Backup from this Setting.
General Properties
Backup Type
Full Perform a full backup.
Differential Specify that the database or file backup should consist only of the portions of the database or file changed since the last full backup.
Transaction Log Specify a backup of the transaction log only.
Note: Support from SQL Server 2012 or later and SQL Azure.
Backup Name
Specify the name of the backup set.
Description
Specify the free-form text describing the backup set.
Password
Set the password for the backup set.
New media set
Create a new media set for the backup. To add a Backup Device or file to the list, click button.
Existing media set
Choose an existing Media set for the backup.
Note: Files and Filegroups option is supported from SQL Server 2012 or later and SQL Azure. Options
Copy only
Specify that the backup is a copy-only backup, which does not affect the normal sequence of backups.
Never expire
Specify the backup set never expire.
Expire after days
Specify the number of days that must elapse before this backup media set can be overwritten.
Expire on
Specify when the backup set expires and can be overwritten.
New Media Set Name (only for New media set)
The name of the new media set.
New Media Set Description (only for New media set)
Specify the free-form text description of the media set.
Use password (only for New media set)
Set the password for the media set.
Append to the existing backup set (only for Existing media set)
Indicate that the backup set is appended to the specified media set, preserving existing backup sets.
Overwrite all existing backup sets (only for Existing media set)
Specify that all backup sets should be overwritten, but preserves the media header.
Check media set name and backup set expiration (only for Existing media set)
Control whether a backup operation checks the expiration date and time of the backup sets on the media before overwriting them.
Media Set Name (only for Existing media set)
Specify the media name for the entire backup media set.
Media set is password protected (only for Existing media set)
Enter the password for the media set.
Verify backup when finished
Check this options to verify the backup.
Perform checksum before writing to media
Continue on error
Instruct backup to continue despite encountering errors such as invalid checksums or torn pages.
Truncate the transaction log (only for Transaction Log backup)
Check this option to truncate the transaction log.
Back up the tail of the log and leave the database in the restoring state (only for Transaction Log backup)
Choose this option to back up the tail of the log and leaves the database in the RESTORING state.
Compress Backup
Specify whether backup compression is performed on this backup.
Note: Support from SQL Server 2008 or later and SQL Azure.
SQL Server Restore
Before starting the restore process, click Generate SQL button to review the SQL. Then, you can click the
Start button to run it. If you want to restore from a file that is not listed in the Object List pane, you can control-click
anywhere in the Object List pane and choose Restore from File.
General Properties for Restore Backup
Restore to Database
Select the database to restore.
Latest possible (only for Transaction Log backup)
Choose this option if do not have the restore point.
Specific time (only for Transaction Log backup)
Specify that the database be restored to the state it was in as of the date and time.
Marked transaction (only for Transaction Log backup)
Specify recovery to a specified recovery point.
Include marked transaction (only for Transaction Log backup)
The specified transaction is included in the recovery, but it is committed only if it was originally committed when the transaction was actually generated.
General Properties for Restore from File
Restore to Database
Latest possible
Choose this option if do not have the restore point.
Specific time
Specify that the database be restored to the state it was in as of the date and time.
Restore Plan
Select the database backup files in the list.
Advanced Properties
Restore database files to
Specify that the data or log file should be moved by restoring it to the location specified in Restore To.
WITH REPLACE
Specify that SQL Server should create the specified database and its related files even if another database already exists with the same name.
WITH RESTRICTED_USER
Restrict access for the newly restored database to members of the db_owner, dbcreator, or sysadmin roles.
WITH KEEP_REPLICATION
KEEP_REPLICATION should used when setting up replication to work with log shipping.
RECOVERY
Roll back all uncommitted transactions. After the recovery process, the database is ready for use.
NORECOVERY
Do not roll back the uncommitted transactions.
STANDBY
Specify a Standby File that allows the recovery effects to be undone.