Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Core Database Administration > Compressing and Shrinking a Database ...

Compressing and Shrinking a Database Manually

Compressing and shrinking a database is a bit different from expanding it, and in many cases, you will want finer control over the process than you get with the Auto Shrink option. Fortunately, you can manage this process manually, and you can also schedule this process on a recurring basis.

To compress or shrink all database files (both data and log files) manually in SQL Server Management Studio, complete the following steps:


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint