SQL 2000 Help

Andy100 · 18 Dec 2007 at 22:26

Something is going seriously squiffy with one of my SQL 2000 databases and I don't know why.

Each of the live databases has a .mdf and .ldf file. Now on one of the databases the .ldf file is ridiculously big.

The .mdf is 2GB and the .ldf is 18GB !

I just backed up the database and the .ldf file grew another 2GB so it seems like it's adding the data to the log file every time I back it up. I thought the backups were supposed to shrink the log files?

Please please please tell me I've missed something simple cos I'm gonna run out of storage on the server soon and then I'll really be in the ****.

teaboy5 · 19 Dec 2007 at 00:22

I will try and help tomorrow

Cant think of the settings at the moment

Burnsy2023 · 19 Dec 2007 at 01:35

It's a common issue. Have a look at these two commands:

http://msdn2.microsoft.com/en-us/library/aa258287.aspx

http://msdn2.microsoft.com/en-us/library/aa258824.aspx

Burnsy

Andy100 · 20 Dec 2007 at 04:17

Just wanted to say thanks.

Truncating the log then shrinking it in Query Analyser worked a treat.

Strange that it wouldn't do it from inside Enterprise Manager, when I tried from there the log stayed the same size. :confused:

All's good now and I can stop *****ing myself that my test server's going to blow up.