Online Documentation for SQL Management Studio for SQL Server

Using services

SQL Studio's integrated features provide an easy way to run all native SQL Server services that are intended for database maintenance. The following services and server tools are available:

To run a service, click its icon or caption on the Desktop Panel and follow the steps of the Wizard. If necessary, you can click the Arrow-down button to open the menu allowing you to specify a template and run the wizard with this template.

To manage configuration files (templates), use the corresponding Manage templates link. In this case you will be redirected to the Template Management section of SQL Studio.

Backup Database

Creates backup copies of your SQL Server databases.

Restore Database

Restores SQL Server databases from previously created backups.

Attach Database

Allows you to attach an existing database to the instance of Microsoft® SQL Server™.

Detach Database

Allows you to detach a database from the instance of Microsoft® SQL Server™.

Shrink Database

Allows you to perform database shrinking on your SQL Server system.

Indices Management

Allows you to perform index management operations in your SQL Server database: reorganizing, rebuilding, disabling.

Update Statistics

Allows you to perform the update statistics operation in your SQL Server database.

Check Database

Allows you to perform the check database operation on your SQL Server system.