I'm worhing with SQL Server7.0 and I have created a database.<br>
I have objets and data in my database<br>
My database have 300Mb and I only need about 50.<br>
How can I reduce to 50 the dimension of my database.<br>
Is it posible??<br>
Any advice will be greatly apreciatted.<p>
Nauj

: I'm worhing with SQL Server7.0 and I have created a database.<br>
: I have objets and data in my database<br>
: My database have 300Mb and I only need about 50.<br>
: How can I reduce to 50 the dimension of my database.<br>
: Is it posible??<br>
: Any advice will be greatly apreciatted.<br>
<br>
: Nauj<br>
: <br>
<br>
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.<br>
<br>
Best Regards,<br>
John K.