Online Documentation for SQL Management Studio for SQL Server

Using services


SQL Studio integrated features provide easy way to run all native SQL Server services which 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.

 

Database Management - Services

 

 

 

 

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™.

 

Indices Management

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

 

Shrink Database

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

 

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.