Software

Ask something
Question Locked

Transaction Log in MS-SQL Data base

0 helpful
2 replies

by sangeet_malhotra

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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

2 replies

by tony hopkinson

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.

This discussion is closed to new replies.