I'm worhing with SQL Server7.0 and I have created a database.
I have objets and data in my database
My database have 300Mb and I only need about 50.
How can I reduce to 50 the dimension of my database.
Is it posible??
Any advice will be greatly apreciatted.
Nauj
Comments
: I have objets and data in my database
: My database have 300Mb and I only need about 50.
: How can I reduce to 50 the dimension of my database.
: Is it posible??
: Any advice will be greatly apreciatted.
: Nauj
:
You say you have "objects and data" - I would get rid of the Objects (pics) BLOB and use instead a character field which would point at a file in a directory - if at all possible. This should save you considerable space - depending on the size of your BLOB, measured in MegaBytes and your other data, measured in bytes.
Best Regards,
John K.