How do I shrink my SQL Server Database?
- by Rory Becker
I have a Database nearly 1.9Gb Database in size
MSDE2000 does not allow DBs that exceed 2.0Gb
I need to shrink this DB (and many like it at various client locations)
I have found and deleted many 100's of 1000's of records which are considered unneeded.
these records account for a large percentage of some of the main (largest) tables in the…