Hi
We run a SQL Server 2003, from which our accounting software runs from. We have ran this for 2 years with no problems, but recently the Transaction LDF file size has being growing very fast, we are now having to detach the Database which the file is linked to, delete the LDF file then restore the database. At one point in a 5 day period it got as big as 150Gb.
What can cause this to happen? and does anyone have any suggestions how this can be stopped? As this is now casusing big problems with data imports etc
I have tried limiting the size of the transaction file but once the file reaches the limit and stops the accounting software from working. Like i said it has been fine for over two years and the file was never a problem.
Thanks in advance
Martin