Re: SBS 2003 R2 SQL Server 2005 Maintenance Plan Doesn't WORK
- From: "bass_player [SBS-MVP]" <bass_player@xxxxxxxx>
- Date: Tue, 10 Jul 2007 12:39:16 +0800
What is your database maintenance plan doing? Have you applied the latest
service pack/hotfix for SQL Server 2005?
"Robert Li [MSFT]" <v-robeli@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:IGqDSLqwHHA.6140@xxxxxxxxxxxxxxxxxxxxxxxxx
Hello,
Thanks for posting in our newsgroup.
From your description, I know that you got an error when trying to save a
Maintenance Plan in SQL Server 2005. If I am off-base, please don't
hesitate to let me know.
I am sorry that is a pure SQL issue, please open a new thread in
Microsoft.public.sql newsgroup. Thanks for your understanding.
If you need further assistance, please don't hesitate to let me know.
Best regards,
Robert Li(MSFT)
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
When opening a new thread via the web interface, we recommend you check
the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.
Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In
doing
so, it will ensure your issues are resolved in a timely manner.
For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.
Any input or comments in this thread are highly appreciated.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
<From: plutz <thelutzs@xxxxxxxxx>
<Newsgroups: microsoft.public.windows.server.sbs
<Subject: SBS 2003 R2 SQL Server 2005 Maintenance Plan Doesn't WORK
<Date: Mon, 09 Jul 2007 19:49:38 -0000
<Organization: http://groups.google.com
<Lines: 30
<Message-ID: <1184010578.302556.145800@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
<NNTP-Posting-Host: 207.191.112.2
<Mime-Version: 1.0
<Content-Type: text/plain; charset="iso-8859-1"
<X-Trace: posting.google.com 1184010578 17384 127.0.0.1 (9 Jul 2007
19:49:38 GMT)
<X-Complaints-To: groups-abuse@xxxxxxxxxx
<NNTP-Posting-Date: Mon, 9 Jul 2007 19:49:38 +0000 (UTC)
<User-Agent: G2/1.0
<X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4,gzip(gfe),gzip(gfe)
<Complaints-To: groups-abuse@xxxxxxxxxx
<Injection-Info: k79g2000hse.googlegroups.com; posting-host=207.191.112.2;
< posting-account=-rTQdQ0AAAB0BTDdt7eTV2r0q4Fz5W4A
<Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!msrtrans!
msrn-in!newshub.sdsu.edu!postnews.google.com!k79g2000hse.googlegroups.com!no
t-for-mail
<Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:49259
<X-Tomcat-NG: microsoft.public.windows.server.sbs
<
<I get an error when I try to save a Maintenance Plan in SQL Server
<2005 that was installed with SBS2003R2 Premium.
<
<TITLE: Maintenance Plan Wizard Progress
<------------------------------
<
<Create maintenance plan failed.
<
<------------------------------
<ADDITIONAL INFORMATION:
<
<Create failed for JobStep 'Subplan'.
<(Microsoft.SqlServer.MaintenancePlanTasks)
<
<An exception occurred while executing a Transact-SQL statement or
<batch. (Microsoft.SqlServer.ConnectionInfo)
<
<The specified '@subsystem' is invalid (valid values are returned by
<sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
<
<Everywhere I search see discussion of SQL Server 2005 Integration
<Services (SSIS). I have found a
<<a href="http://support.microsoft.com/kb/909036";>MSKB</a> that
<discusses how to install SSIS, but I have also read that the SQL
<Server 2005 Workgroup does not support SSIS.
<
<What am I to do?
<
<Philip
<
<
.
- Follow-Ups:
- References:
- SBS 2003 R2 SQL Server 2005 Maintenance Plan Doesn't WORK
- From: plutz
- RE: SBS 2003 R2 SQL Server 2005 Maintenance Plan Doesn't WORK
- From: Robert Li [MSFT]
- SBS 2003 R2 SQL Server 2005 Maintenance Plan Doesn't WORK
- Prev by Date: Re: exchange web & remote web workplace pages do not load
- Next by Date: Re: SBS2003R2>Windows Mobile>Verizon>Motorla Q phone
- Previous by thread: RE: SBS 2003 R2 SQL Server 2005 Maintenance Plan Doesn't WORK
- Next by thread: Re: SBS 2003 R2 SQL Server 2005 Maintenance Plan Doesn't WORK
- Index(es):
Relevant Pages
|
