In the Restore Database window, select the database and the backup sets to restore, and press OK. How to Restore a Backup Using T-SQL Alternatively, you can use the T-SQL commands to restore a ...

7. If your SQL command is something you might use in the future, click the Save button or press Ctrl+S and give it a descriptive name so it’s easy to find later.

Many people are confused by various JOIN operations supported by SQL. Learn to master the SQL command line with this crash course in JOIN syntax.