Sql Server : ShrinkDatabase Options
- Posted by Sqltimes
- On January 23, 2016
- 0 Comments
Though rarely, we do need to run shrink commands in our lab database environments. The easiest way is to run the SHRINKDATABASE command is : Simple Option 1 2 3 4 5 -- -- Sample database shrink command -- DBCC SHRINKDATABASE(SampleDB) GO Targetted Shrink Above command shrinks the database to the point where there is […]
Read More