BACKUP and RESTORE Statements (Transact-SQL)

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.