February 10, 2009 at 8:44 pm
Hello People
Recently a person in the IT department decided in there wisdom to switch off my pc, which runs a local DBA SQL2005 Instance for Monitoring. Since then I have been getting error messages when I try to access maintenance plans , agents, alerts and so on.
I've run a dbcc checkdb against all my local dbs and they came back okay.
I've created a new backup maintenance plan and could not run it from the maintenance plan section under management studio. I could however run the job agent (which was successful).
On rebooting my PC the maintenance plan I had just created disappeared.
My questions are these -
Is something wrong with the msdb db ?
How do I know go about fixing the problem (I understand my previously created plans have gone, but I do have scripts so no big loss) ?
Does have SPs installed make any difference to the solution (Now my pc instance at SP3) ?
Thanks in Advance
Adonia
February 10, 2009 at 9:19 pm
That sounds strange. It almost sounds like some of the SQL files are corrupt. I might uninstall and reinstall the tools.
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
February 10, 2009 at 11:22 pm
Adonia Delavigne (2/10/2009)
Since then I have been getting error messages when I try to access maintenance plans , agents, alerts and so on.
What errors?
Does have SPs installed make any difference to the solution (Now my pc instance at SP3) ?
It's good for client and server to be on the same service pac, but since this is a local instance, that's not applicable.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply