October 15, 2007 at 2:32 pm
Hi everyone,
Has anyone read this book, and can they say whether they think it is worth reading or buying?
Microsoft SQL Server 2005 High Availability with Clustering & Database Mirroring
http://mhprofessional.com/product.php?isbn=0071498133
Just wondering.
I am still trying to resolve problems with SQL Server Agent and feel like I need to learn more about clustering to make sense of the environment I am working with. That's because I'm wondering whether or not the problems are related to something in the cluster. I want to rule out or rule in the clustering in a methodical way.
The basic issues I'm seeing are:
1. No job information is being written to the job history.
2. The cleanup job I have that uses master.dbo.xp_delete_file is not deleting files.
3. Errors like these keep showing up in the Windows event log and SQL Agent Error Log:
Windows Event Log (shows up every few seconds):
Event Type:Error
Event Source:MSSQLSERVER
Event Category: (3)
Event ID:19019
Date:10/15/2007
Time:4:09:38 PM
User:N/A
Computer:
Description:
[sqsrvres] OnlineThread: Could not connect to server but server is considered up.
SQL Agent Error Log (shows up every 1-5 minutes):
Date10/15/2007 4:00:00 PM
LogSQL Agent (Current - 10/15/2007 4:16:00 PM)
Message
[382] Logon to server '[server]' failed (ConnAttemptCachableOp)
If there are any other resources that give good information on SQL Server 2005 clustering or about Agent (troubleshooting jobs, maintenance plans, etc.), I would be very grateful if someone could point me to them. I feel that there are too many errors and I want to get the system back under control.
I think part of the issue is that the server I am working with is SQL 2005 SP1 and needs to be brought up to SP2. But the way things are divided here, our systems group has been handling the installation of SQL and cluster setup, plus of course any maintenance time would need to be negotiated, so I want to make sure as much as I can that if I propose going to SP2 that there will be some real benefit in solving these problems.
Thanks!
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
October 16, 2007 at 6:48 am
there's not really enough info to make any guess on your problems. clustering per see should not affect the agent - but it all depends upon the way security and the service accounts are set up. I've never really fond any differences working with clusters - but it does depend if the server has been configured correctly - it's always best to have the lastest servcie packs installed - especially with sql 2005 which hasn't been very good - you'd need porbably the latest rollup for sp2 too - last thing I'd do is run in sp2 alone.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
October 16, 2007 at 9:19 am
colin Leversuch-Roberts (10/16/2007)
there's not really enough info to make any guess on your problems. clustering per see should not affect the agent - but it all depends upon the way security and the service accounts are set up. I've never really fond any differences working with clusters - but it does depend if the server has been configured correctly - it's always best to have the lastest servcie packs installed - especially with sql 2005 which hasn't been very good - you'd need porbably the latest rollup for sp2 too - last thing I'd do is run in sp2 alone.
Thanks. Yes, it does seem like we need to go to SP2. We are running SP1 now, and I wonder whether the SQL Server Agent problems and the problem with the file deletion stored procedure I'm seeing are due to the service pack lag.
I'll post the results after the changes.
Thanks again,
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply