January 1, 2006 at 11:24 pm
Hi,
I'm very much new to SQL Server Administration, this is a scenario I have come across and I need your help, when I try Log shipping, I would be getting an error: 8649 because of which I would not be able to run the the maintenance plans and as I searched the KB of Microsoft I find that this is caused because of the SP that we have and need to download the latest one.
KB Says:
This problem occurs because the DBCC CHECKDB statement checks the server-wide query governor cost limit time setting, but it ignores the session time setting QUERY_GOVERNOR_COST_LIMIT that is set by the SET QUERY_GOVERNOR_COST_LIMIT statement. Because of this error, the following conditions occur:
|
• |
You cannot use maintenance plans with the query governor cost limit server setting and a reasonable database size. |
|
• |
You cannot do a database integrity check in a Database Maintenance Plan. |
RESOLUTION
Service pack information
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000.
Please advice.
Thanks in advance.
Raghu Pyapili
January 4, 2006 at 8:00 am
This was removed by the editor as SPAM
January 4, 2006 at 11:10 am
No idea here. You might need to call PSS, but I suspect they'll tell you SP4.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
January 5, 2006 at 4:12 pm
We perform SQL 2000 log shipping across the internet through a VPN. What does the Governor cost limit refer to?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply