{"id":109,"date":"2012-01-10T05:23:19","date_gmt":"2012-01-10T05:23:19","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/01\/10\/shrink-database\/"},"modified":"2012-01-10T05:23:19","modified_gmt":"2012-01-10T05:23:19","slug":"shrink-database","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/01\/10\/shrink-database\/","title":{"rendered":"SHRINK Database"},"content":{"rendered":"

Following are the Steps to SHRINK Database in SQL Server.<\/p>\n

1) Connect to the SQL Server in SSMS<\/p>\n

2) Expand Databases<\/p>\n

3) RightClick on the Database to be shrinked, Click on Tasks then on Shrink.<\/p>\n

4) Here you will have two options:<\/p>\n

\n Shrink Database
\nShrink Files<\/p>\n

Using Database option you can shrink the database as a whole
\nFiles option lets you shrink each file associated with the database seperately.<\/p>\n

\"Shrink<\/a>
Shrink Database<\/figcaption><\/figure><\/dd>\n

5) Select Database<\/p>\n

6) Now in the Shrink Database Popup Click OK<\/p>\n

\"Shrink<\/a>
Shrink Database Popup<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"

Following are the Steps to SHRINK Database in SQL Server. 1) Connect to the SQL Server in SSMS 2) Expand Databases 3) RightClick on the Database to be shrinked, Click on Tasks then on Shrink. 4) Here you will have two options: Shrink Database Shrink Files Using Database option you can shrink the database as…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32,41,273,610],"tags":[690,691,692,693,694,695,696,697,698,699,700],"class_list":["post-109","post","type-post","status-publish","format-standard","hentry","category-configuring-sql-server","category-sql-server-basics","category-sql-server-management","category-tools","tag-how-to-shrink-database-in-sql-server","tag-sep-by-step-shrink-database-sql-server","tag-seps-to-shrink-database-sql-server","tag-shrink","tag-shrink-files-separately-in-sql-server","tag-shrink-ldf-files-in-sql-server","tag-shrink-mdf-files-in-sql-server","tag-steps-to-shrink-database-in-sql-server","tag-what-is-shrink-database-in-sql-server","tag-what-is-shrink-files-in-sql-server","tag-why-is-shrink-used-in-sql-server"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=109"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/109\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}