Reduce a SQL Server7.0 database

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'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

    :



    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.


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories