September 19, 2008 at 1:42 pm
OK, I'm really confused. Do you want to increase memory or eliminate the log full alerts?
-- You can't be late until you show up.
September 22, 2008 at 10:38 am
I am sorry for confusion, I am trying make sure that nothing wrong with the servers. If I get an error alerts and it doesn't mean anything I am fine, but if alert mean something I need to know, so I want to get alerts. My understanding how you explain,Full msdb log it is o'k, but temp log is full, I need to increase temp memory right?Thank you
September 22, 2008 at 10:44 am
By default, msdb is not really using the log as it's set to simple recovery mode (truncates on checkpoint) so growth should be relatively small if at all. TempDb is used for a lot of different things so the file size should be increased. This has nothing at all to do with memory but everything to do with disk space.
Edit: and let's be clear, if you do increase the physical size of temp, it's permanent, not temporary.
-- You can't be late until you show up.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply