I want to reduce my Sybase DB size

[arsahd]

Is there any way to delete some unused records from tables and reduce DB
size.
Thanks in advance
Rafey.

[Bill Robinette]

To my knowledge there is no way to reduce the size of a database without
deleting it and recreating from scratch. This presents a problem becuase you
cant dump the database and create a new one from load. You could bcp all the
data out then create the DB.
Keep in mind when building a database it is better to make it small then
increase the size as needed.

arsahd wrote in message ...

[Susan Brower]

Rafey,
I remember seeing this same question last month in one of the other news
groups (maybe the SQL Server or Performance and Tuning group.) Someone
replied to the query with detailed instructions on how to shrink a database
without dropping and recreating it. I know it involves updating the system
tables. It looked very dangerous to me.
Happy hunting, Susan Brower

[workerbee]

There is no *Sybase Supported* way of doing it. But there are ways, you
need to take the risk of playing with sysusages table, and you have to be
absolute sure what you are doing.

--
the WorkerBee
http://www.PriceHive.com
Buy books Online? We compare prices from major online bookstores!

Bill Robinette <William....@ValueOptions.com> wrote in message
news:ZzKmIU8V$GA....@forums.sybase.com...

> To my knowledge there is no way to reduce the size of a database without
> deleting it and recreating from scratch. This presents a problem becuase
you
> cant dump the database and create a new one from load. You could bcp all
the
> data out then create the DB.
> Keep in mind when building a database it is better to make it small then
> increase the size as needed.
>
>
> arsahd wrote in message ...