Transaction Log in MS-SQL Data base

By sangeet_malhotra ·
We are using SAP ECC 5.0 and using MS-SQL 2000 as our backend. Our Transaction Log file has touched 85 GB whereas our DB size is approx. 65 GB. We are not able to perform many activities and not able to take backup of Transaction Log also. What should be done? Please help

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -


by Tony Hopkinson In reply to Transaction Log in MS-SQL ...

sql 2000 dump no_log

in google, you'll get a bunch of things to try.

When you've done it read up about dumping your transaction logs and may be shrinking them to get you down to a more sensible size.

Basically if you don't do anything with them, they just grow.

Related Discussions

Related Forums