Need to resize a SQL 2000 database
Posted on 2013-05-30
I was asked to assist in converting a low use SQL 2000 server to a virtual machine for a small network. This server is primarily used for historical trend data and has had the historical database file size is configured to 450GB on a 600GB drive. There is approximately two years worth of historical data stored on the database in which only 34 of the 450GB is used. Why the database file size was configured for 450GB in the first place is beyond me.
I've read that there has been issues with shrinking a database on a regular basis, but is there anything to be worried about when doing this as a one time thing?
Also, I've never had to shrink a database before. What is the best way to shrink the database to a more reasonable size? Say 50GB.