Online Documentation for SQL Management Studio for SQL Server
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.
Creates backup copies of your SQL Server databases.
Restores SQL Server databases from previously created backups.
Allows you to attach an existing database to the instance of Microsoft® SQL Server™.
Allows you to detach a database from the instance of Microsoft® SQL Server™.
Allows you to perform index management operations in your SQL Server database: reorganizing, rebuilding, disabling.
Allows you to perform database shrinking on your SQL Server system.
Allows you to perform the update statistics operation in your SQL Server database.
Allows you to perform the check database operation on your SQL Server system.