Optimize SQL Databases with Microsoft SQL Server Management Studio

A previous article talked about how to shrink a database manually to optimize it. This is a good way to do it, but it requires to run a query, which some users might find complicated. In this article how to easily shrink your SQL database with Microsoft SQL Server Management Studio

1. Open Microsoft SQL Server Management Studio, and connect to your database:

shirnk database arvixe windows hosting connect to database

Note: If you don’t know how to connect to your databases with Microsoft SQL Server Management Studio, please watch this video.

2. In the object explorer, select your database and right click on it. Then go to menu “Tasks -> Shrink -> Database”:

database task sql arvixe

3. Now, on the Shrink Database window, click Ok to shrink it:

database task sql arvixe

4. Wait for the process to finish. It can take a while, depending on the size of the database:

shinking database arvixe tutorials

5. And that’s it! The database has been optimized!

This concludes Optimize SQL databases with Microsoft SQL Server Management Studio

Looking for quality ASP Web Hosting? Look no further than Arvixe Web Hosting!

Happy Hosting!

Rodolfo Hernandez

Tags: , , , , , , , , , , , , , , , , , , , , | Posted under ASP .NET 3.5, DotNet/Windows Hosting, WebsitePanel Tutorials, Windows Server Admin | RSS 2.0

Author Spotlight

Rodolfo Hernandez

Rodolfo Hernandez

I like photography and reading books. Currently working for Arvixe as Elgg Community Liaison. Elgg Security Expert Web Security Expert CEO of UDP SW Social Web

Leave a Reply

Your email address will not be published. Required fields are marked *


+ 2 = 10

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>