I tried this and it didn't work, thanks for the suggestion. Still looking for a solution.
Davis Ralph <Ralph.[Email address protected] wrote: **A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as normal
**Anything below this line is the original email text
I would try opening your client network utility and unclick the "enable
shared memory protocol" in the lower left corner. Then save and retry
your maintenance plan.
Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************
-----Original Message-----
From: Ben Helfer
[Email address protected]
Sent: Monday, January 23, 2006 6:25 PM
To: LazyDBA Discussion
Subject: Database job - System databases fail
I've created two database maintenance plans. One for user databases and
one for system databases. The backup job for the users databases runs
flawlessly. The backup job for the system databases generates the
following error listed below. Any suggestions?
Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO
(ODBC SQLState: 08001)] Error 0: [Microsoft][ODBC SQL Server
Driver][Shared Memory]Invalid connection.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(Invalid Instance()).
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Confidentiality Note: The information contained in this message, and any
attachments, may contain confidential and/or privileged material. It is intended
solely for the person or entity to which it is addressed. Any review,
retransmission, dissemination, or taking of any action in reliance upon this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and delete
the material from any computer.
MS Sql Server LazyDBA home page