| Chris Hoare 2006-11-30, 7:14 pm |
| Hi
If you could do it you would do it with alter database; sadly you can't you
can only grow a databases minimum size not reduce it. If the database is
bigger than the minimum size then you can shrink it with alter database
(using the size field)
If its smaller than the minimum size then the easiest thing to do is create
a new database with a smaller minimum size and copy the tables/ code and
data to it; you can then restore this over the current database. There are
benefits in having a larger database as it doesnt need to grow as often which
improves performance.
Chris
> I have a database file that is 3gb and all attempts to shrink it says you
> cannot shrink database beyond minimum limit 3gb. I have tried both shrink
> database and shrinkfile statements. Is there a way to overide the minimum
> limit? Any assistance will be very much appreciated. Thanks.
|