How to backup and restore an SQL Server database

Backup and restore an SQL Server database for recovery scenarios.

The following URLs contain guidelines for backup and restore of an SQL Server database:

Operation	URL
Create a full database backup	https://msdn.microsoft.com/en-us/library/ms187510.aspx
Create a differential database backup	https://msdn.microsoft.com/en-us/library/ms188248.aspx
Create a transaction log backup	https://msdn.microsoft.com/en-us/library/ms179478.aspx
Completely restore a database backup	https://msdn.microsoft.com/en-us/library/ms177429.aspx https://msdn.microsoft.com/en-us/library/ms175510.aspx https://msdn.microsoft.com/en-us/library/ms177446.aspx