April 21, 2009 at 10:10 am
When I attach a database to a 2005 server that was from a 2000 I see these message. I check the databases after and auto_close is 0. Is this an indication of a problem? Everything else seems OK. This was just a test so I have not used the database yet.
2009-04-21 10:04:10.74 spid55 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2009-04-21 10:04:10.74 spid55 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2009-04-21 10:04:10.74 spid55 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
April 21, 2009 at 11:52 am
Was AutoClose set to True (1) when this database was part of SQL 2000? If you change the Auto_close of the model databsae to false (0) and then reattach will the Autoclose now be set to False?
In general this is a good thing that Auto_close is set to False. Unless you have a really good reason why you want it set to True this is one option that should be left at its default of false. So my opinion is this behavior is not a problem but rather a good thing.
Francis
April 21, 2009 at 11:57 am
thanks Francis.
I am concerned about the massages I got. I saw that you get them with auto_close on. In my case since it is off, not sure why I got them.
April 21, 2009 at 12:09 pm
Those errors are normal. But you may want to check out http://support.microsoft.com/kb/917828 especially if you do not have SP2 installed.
Francis
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply