LDF file management Question

[rtdvoip]

Hiya Fellas,
Can anyone shed some light on how I may backup/delete
the LDF data file on my database that has grown to be about 1.4 Gig. I have tried serveral options but no go.

Thanks in advance for the help,
rtdvoip

 

[zhavic]

Im doing it this way: ( but there may be more safety way )

1. detach database
2. move log file to another location
3. attach database ( it will create new log file )
4. if it is OK, delete previous ( moved ) log file
5. if it is not OK, return moved log file to it's original place and attach database
( I have never needed step 5 )


Zhavic

---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.

 

[nigelrivett]

Do you have the database in full recovery mode and aren't making log backups?

If so then change it to simple and then shrink the log file - you can do this via enterprise manager or query analyser.

Whatever you do make sure you have a backup first.

======================================
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.