Skip to main content

Overview

SQL Server Management Studio (SSMS) is the official graphical tool for managing SQL Server. This guide walks through how to back up and restore a database entirely through its interface, with no scripting required.

All backup and restore operations in this guide produce or consume .bak files, which is SQL Server's native backup format.