change database size after database was created

change database size after database was created

Post by Amy Fa » Thu, 06 Sep 2001 23:33:18



When the database was created, the creator made 10G for
primary data file. But after a year of data growing, the
real size of the database is only 1G. It is a wasting of
space, plus the database was setup as automatical growing.
Is there a way of shrinking the database to 1G without re-
creating a new database? Thanks for anyone of advice.
 
 
 

change database size after database was created

Post by Dinesh.T.K » Fri, 07 Sep 2001 00:08:38


Amy,

Refer
 DBCC SHRINKDATABASE / DBCC SHRINKFILE in BOL.

Dinesh.