Reduce a SQL Server7.0 database - Programmers Heaven

Howdy, Stranger!

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

Categories

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.