I have an MSSQL Server 8.0.2039.
I have 4 user databases on this server. The transaction logs for 3 of the databases grow normally and are usually ok to shrink with a script that can shrink it down.
The problem is with the fourth database. It grows exponentially (usually about 2GB a day). This database has our reporting data on it and is typically only connected when we are running reports. There are 2 ways that we are using to connect. One is with a VB program I created to do the reporting and copying of data from one database (Sybase) to the other. The other way is with an Access DB Program.
I have no idea why this database is the only one that has a transaction log that grows exponentially. Once a week we have to run the script that shrinks the transaction log. This normally will take around 10 minutes to complete (where the others take only about 1 minute to complete).
Where can I look, what tools can I use to help diagnose why this transaction log grows so much?
Thanks in advance for any and all help!