Reduce size allocated to a database

We have allocated 10GB to a production database in SQL Server 2000 and we
find that it only uses around 600MB in size.
Can we change the size allocated from 10GB to say 3GB ? Is there any steps
we have to perform before the change ? Does the benefit of changing the
size is only saving in disk space ?
Thanks
Mark
If you want to reduce a physical size if the database , so run DBCC
SHRINKFILE command
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:OjMhzkj%23FHA.3036@.TK2MSFTNGP09.phx.gbl...
> We have allocated 10GB to a production database in SQL Server 2000 and we
> find that it only uses around 600MB in size.
> Can we change the size allocated from 10GB to say 3GB ? Is there any
> steps we have to perform before the change ? Does the benefit of changing
> the size is only saving in disk space ?
> Thanks
>
|||> Does the benefit of changing the size is only saving in disk space ?
Yes. You pay no penalty for having a large database file with SQL Server. Some additional comments
about shrink: http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:OjMhzkj%23FHA.3036@.TK2MSFTNGP09.phx.gbl...
> We have allocated 10GB to a production database in SQL Server 2000 and we find that it only uses
> around 600MB in size.
> Can we change the size allocated from 10GB to say 3GB ? Is there any steps we have to perform
> before the change ? Does the benefit of changing the size is only saving in disk space ?
> Thanks
>
|||Dear Uri,
Do you mean that after changing the Database file size, I have to run DBCC
SHRINKFILE ?
Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OAOaG8j%23FHA.2452@.TK2MSFTNGP11.phx.gbl...
> Mark
> If you want to reduce a physical size if the database , so run DBCC
> SHRINKFILE command
>
>
> "Mark" <Mark@.discussions.microsoft.com> wrote in message
> news:OjMhzkj%23FHA.3036@.TK2MSFTNGP09.phx.gbl...
>