July 16th, 2004, 04:04 PM
|
|
Contributing User
|
|
Join Date: Oct 2003
Location: Cincinnati, OH USA
Posts: 111
Time spent in forums: 1 m 3 sec
Reputation Power: 6
|
|
|
Transaction Log problem
For some reason, the transaction log for one of the databases on the server became huge (20 GB)!! The database is just a test database, and all of the settings are the same as all of the other databases.
The only thing I know that was changed in the past 2 months was the Compatibility Level. It was changed from 65 to 80.
Does anyone know if this could cause this type of problem with the transaction log? It's set to Automatically Grow File, by 10%, unrestricted file growth. All of these settings are the same as other databases.
Any ideas?? Thanks in advance!
Jill
Last edited by jstrohofer : July 22nd, 2004 at 01:55 PM.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
