BACKUP and RESTORE Statements (Transact-SQL)

  • Article

SQL Server enables you to back up and restore your databases. Additionally, you can export and import security certificates and keys. The SQL Server backup and restore component provides an important safeguard for protecting critical data.

In This Section

BACKUP (Transact-SQL)

BACKUP CERTIFICATE (Transact-SQL)

BACKUP MASTER KEY (Transact-SQL)

BACKUP SERVICE MASTER KEY (Transact-SQL)

RESTORE Statements for Restoring, Recovering, and Managing Backups (Transact-SQL)

RESTORE MASTER KEY (Transact-SQL)

RESTORE SERVICE MASTER KEY (Transact-SQL)

See Also

Concepts

Back Up and Restore of SQL Server Databases