by Fang Jin » Wed, 10 Dec 1997 04:00:00
I want to decrease the size of the Database Size and Database Device
size, because the Database occupy two much space in the Windows NT Server.
But I don't know how to reach it.
Would you please tell me how to do it?
Thank you very much!
Fang Jing
by David Kai Hong Cho » Thu, 11 Dec 1997 04:00:00
You can minimize the database size but not the database device size. WhatQuote:> I want to decrease the size of the Database Size and Database Device
>size, because the Database occupy two much space in the Windows NT Server.
>But I don't know how to reach it.
> Would you please tell me how to do it?
> Thank you very much!
> Fang Jing
1. Create another database in another device
2. Use Object Transfer to transfer the database to the new device
3. Drop the old device and delete that file accordingly
Hope this helps
David
by Sergei Didu » Thu, 11 Dec 1997 04:00:00
It easy to change DB size using MS SQL Enterprise Manager.
(Edit Database/Expand or Shrink), but you can only expand device.
--
Sergei Didur
Quote:> I want to decrease the size of the Database Size and Database Device
> size, because the Database occupy two much space in the Windows NT
Server.
> But I don't know how to reach it.
> Would you please tell me how to do it?
> Thank you very much!
> Fang Jing
1. Shrinking the size of a device / database
I have created a data device of 60 MB and a log device of 30 MB on a
SQL Server. I have created a database using these devices making a
database of 90 MB. It is now several months later and I want to use
this space for something else, since it turn out the database only
requires 15 MB. How can I shrink the database to go on a data device of
30 MB and log of 15 MB ?
ALTER can only increase the size of the database and when I use
dump/load database, it insists the old database size of 90 MB be
maintained. I have tried bcp, but am unclear on how to use it. The manual
does not give a clear example and the FAQ does not either.
Thanks for your help in advance.
--
Systems Engineer
SHL Systemhouse Inc., Ottawa Branch, 50 O'Connor Street, Suite 501,
Ottawa, Ontario, Canada, K1P 6L2, 613-236-9734
2. Help Needed.......Linking a Slider Control to a DataControl...Can this be done?
3. Device size and database size
6. Database size bigger than device size???
7. data space (database size) how database size calculate for known record numbers
8. How Do I Shrink The Size Of A Data Device (Newbie)
9. Shrinking allocated size of af SQL 7.0 database
10. How to shrink the database size?