September 8, 2005 at 12:57 pm
I have seen threads here and on other sites about problems with SP4, but I haven't seen this problem mentioned. I recently installed SQL Server 2000 SP4 on a server. Since then two (out of 19) of the user dbs have begun acting as if their recovery models are full instead of simple. Their transaction logs grow until they are backed up or I run a checkpoint. The recovery model still appears to be set to Simple, and it doesn't seem to be happening with any of the other dbs on the server, so I'm really puzzled. Thanks in advance for any suggestions.
September 12, 2005 at 8:00 am
This was removed by the editor as SPAM
September 12, 2005 at 4:29 pm
Have you executed DBCC CHECKDB and DBCC CHECKALLOC against the databases ?
Have you executed UPDATE STATISTICS against the databases ?
Have you tried altering one of the 'quirky' database recovery mode to simple and back to full ?
How often are your transaction logs backed up ?
Has user activity changed ?
Have you tried (ughh ... I hate to say it) stopping and restarting SQL Server, maybe even rebooting the server itself ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply