Shrinking/Compacting Data files and transaction Log files??

[holly]

Hi

How do I Shrink/Compact a Data file and transaction Log file within SQL server (2000) ??

Thanks for your help

[holly]

Hi,

Plz Help!!

Does anyone know the answer??? Can this be done??

Thanks

[MrGTI]

In Enterprise Manager, right click on db, choose all tasks, then shrink database.

Click files button at bottom of form, and change the combobox labeled database file to <databasename>_log.

Then press okay.

[holly]

Hi

Thanks for replying, Your solution will only shrink the total amount
of allocated space. I need to reduce the actual data size to
1000mb and keep the allocated total at 2000mb ???

Thanks

[MrGTI]

If it's that big, it means it has that much data in it.

Make sure you're using varchar instead of char datatypes.