Transaction Log grown around 6G in my disk

[28814840]

Hi all,

As my SQL 2000 server have the transaction log grown around 6G, Can I used any steps to reduced the size?
Command line or SQL Enterprise Management can do this?

Please help me since my system drive may be full very soon?

Regards, Benny

 

[nigelrivett]

Set the recovery model to simple then shrink the log.
Right click on database, properties then options - simple
Right click on database, all tasks, shrink database.

Have a look in bol about recovery strategies.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[JBaileys]

Once all your transactions are commited, you may try :
backup <database> to diskdump truncate_only

Check bol for syntax as i'm just taking this from memory.

 

[mrshardee2]

Try going into Query Analyzer and running:
BACKUP LOG <database> WITH TRUNCATE_ONLY
Then go into enterprise manager, look at your database in TaskPad view. At the bottom, there is a section titled "Space Allocated". Hover over the arrow beside the title and a menu will appear. Click on "Shrink Database".
Make sure that "Maximum free space" is set to what you want it (mine is 0%), and click ok. Once this runs and you refresh, your TLogs should be drastically smaller.


Amber