{"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":"<p>Following are the Steps to SHRINK Database in SQL Server.<\/p>\n<p>1) Connect to the SQL Server in SSMS<\/p>\n<p>2) Expand Databases<\/p>\n<p>3) RightClick on the Database to be shrinked, Click on Tasks then on Shrink.<\/p>\n<p>4) Here you will have two options:<\/p>\n<dd>\n   Shrink Database<br \/>\nShrink Files<\/p>\n<p>Using Database option you can shrink the database as a whole<br \/>\nFiles option lets you shrink each file associated with the database seperately.<\/p>\n<p><figure id=\"attachment_1391\" aria-describedby=\"caption-attachment-1391\" style=\"width: 290px\" class=\"wp-caption aligncenter\"><a href=\"\/wp-content\/uploads\/2012\/01\/Shrink-Database1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2012\/01\/Shrink-Database1.jpg\" alt=\"Shrink Database\" title=\"Shrink Database\" width=\"290\" height=\"300\" class=\"size-medium wp-image-1391\"><\/a><figcaption id=\"caption-attachment-1391\" class=\"wp-caption-text\">Shrink Database<\/figcaption><\/figure><\/dd>\n<p>5) Select Database<\/p>\n<p>6) Now in the Shrink Database Popup Click OK<\/p>\n<figure id=\"attachment_1386\" aria-describedby=\"caption-attachment-1386\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/sqlserverlearner.com\/wp-content\/uploads\/2012\/01\/Shrink-Database-Popup.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/sqlserverlearner.com\/wp-content\/uploads\/2012\/01\/Shrink-Database-Popup-300x270.jpg\" alt=\"Shrink Database Popup\" title=\"Shrink Database Popup\" width=\"300\" height=\"270\" class=\"size-medium wp-image-1386\"><\/a><figcaption id=\"caption-attachment-1386\" class=\"wp-caption-text\">Shrink Database Popup<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>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&hellip;<\/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],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/109"}],"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}]}}