Learn Microsoft Training with Free Lessons & Tips

1. Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance.
2. Expand the Databases node in Object Explorer.
3. Right-click the database, hover over Tasks, and select Back up....
4. Under Destination, confirm that the path for your backup is correct.

A deadlock occurs when two or more processes or transactions block each other from continuing because each has locked a database resource that the other transaction needs. SQL Server handles deadlocks by terminating and rolling back transactions that were started after the first transaction.

The best way to learn SQL is through hands-on practice in a course that's designed to give you real-world SQL skills. DataCamp's online courses take you from an SQL newbie to a master of the database query, all while learning SQL at your own pace and from anywhere in the world.

Drawing Clearer Distinctions With An Azure And Microsoft SQL Server. As a cloud-based relational database service, Microsoft SQL in Azure offers many of the same features as SQL Server. However, Azure SQL includes extra cost-saving features, such as scaling on demand and paying only for what you use.

SQL Server Express is a full database engine, containing much of the same functions and features as SQL Server Standard.  It also includes the SQL Server Management Studio for more advanced management and configuration of the database.