Someone help me please. I'm confused.
I've got a brand new Maintenance Plan which reorganizes indexes, clears out
the MP history and updates DB stats. It refused to save with a schedule of
once a week on Sunday at 1:00 a.m., but did save without a schedule (on
demand).
I have reopened the Maintenance Plan and tried to create a schedule. Every
time I try to close out and save (X on the upper right), it gives me the
Error: "GUID should contain 32 digits with 4 dashes
(xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
information.
What is going on? Does anyone know? Help would be appreciatedd since we're
right on top of our official 2000-to-2005 server switch over.
Thanks,
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)Check this link out, hopefully it should resolve your issue.
http://www.kbalertz.com/Feedback_922651.aspx
Bob
"Catadmin" wrote:
> Someone help me please. I'm confused.
> I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> the MP history and updates DB stats. It refused to save with a schedule of
> once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> demand).
> I have reopened the Maintenance Plan and tried to create a schedule. Every
> time I try to close out and save (X on the upper right), it gives me the
> Error: "GUID should contain 32 digits with 4 dashes
> (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> information.
> What is going on? Does anyone know? Help would be appreciatedd since we're
> right on top of our official 2000-to-2005 server switch over.
> Thanks,
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)|||Just an FYI. I tried creating a new job that contained the above 3 steps and
the Notify Operator (set with a fail precendence from the other three tasks)
for another user db. I hit save, then the X up in the right hand corner and
got the following error message:
"Apply to target server failed for job 'MyJobName' "
I did get this error message on the other job and wonder if maybe there's a
connection between this and the GUID message?
Thanks,
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Catadmin" wrote:
> Someone help me please. I'm confused.
> I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> the MP history and updates DB stats. It refused to save with a schedule of
> once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> demand).
> I have reopened the Maintenance Plan and tried to create a schedule. Every
> time I try to close out and save (X on the upper right), it gives me the
> Error: "GUID should contain 32 digits with 4 dashes
> (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> information.
> What is going on? Does anyone know? Help would be appreciatedd since we're
> right on top of our official 2000-to-2005 server switch over.
> Thanks,
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)|||No these issues are not related. The second issue you are seeing is probably
because you are using SQL Server Management studio to connect to a server
which is not local. If you terminal service to the machine itself and use sa
account to connect to it from there then you shouldn't see this issue. This
issue is somehow related to security but haven't found a solution yet.
Bob
"Catadmin" wrote:
> Just an FYI. I tried creating a new job that contained the above 3 steps and
> the Notify Operator (set with a fail precendence from the other three tasks)
> for another user db. I hit save, then the X up in the right hand corner and
> got the following error message:
> "Apply to target server failed for job 'MyJobName' "
> I did get this error message on the other job and wonder if maybe there's a
> connection between this and the GUID message?
> Thanks,
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)
>
> "Catadmin" wrote:
> > Someone help me please. I'm confused.
> >
> > I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> > the MP history and updates DB stats. It refused to save with a schedule of
> > once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> > demand).
> >
> > I have reopened the Maintenance Plan and tried to create a schedule. Every
> > time I try to close out and save (X on the upper right), it gives me the
> > Error: "GUID should contain 32 digits with 4 dashes
> > (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> > information.
> >
> > What is going on? Does anyone know? Help would be appreciatedd since we're
> > right on top of our official 2000-to-2005 server switch over.
> >
> > Thanks,
> >
> > Catadmin
> > --
> > MCDBA, MCSA
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the back?
> > @.=)|||Bob,
I appreciate the link, but this has nothing to do with SSIS or an
importanted maintenance plan. I'm actually creating this plan from scratch
in the GUI of SSMS and getting this error.
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Bob" wrote:
> Check this link out, hopefully it should resolve your issue.
> http://www.kbalertz.com/Feedback_922651.aspx
> Bob
> "Catadmin" wrote:
> > Someone help me please. I'm confused.
> >
> > I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> > the MP history and updates DB stats. It refused to save with a schedule of
> > once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> > demand).
> >
> > I have reopened the Maintenance Plan and tried to create a schedule. Every
> > time I try to close out and save (X on the upper right), it gives me the
> > Error: "GUID should contain 32 digits with 4 dashes
> > (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> > information.
> >
> > What is going on? Does anyone know? Help would be appreciatedd since we're
> > right on top of our official 2000-to-2005 server switch over.
> >
> > Thanks,
> >
> > Catadmin
> > --
> > MCDBA, MCSA
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the back?
> > @.=)|||Bob,
You are correct. I am connected on my desktop with SSMS to a remote server.
So, you're saying I actually have to use a remote connection like VPN/Remote
Desktop to get onto the actual server and create the maintenance plan there?
That stinks. I hope they fix this soon as we only allow one TS connection
to the machine at a time and there are several of us doing different parts of
our upgrade project.
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Bob" wrote:
> No these issues are not related. The second issue you are seeing is probably
> because you are using SQL Server Management studio to connect to a server
> which is not local. If you terminal service to the machine itself and use sa
> account to connect to it from there then you shouldn't see this issue. This
> issue is somehow related to security but haven't found a solution yet.
> Bob
> "Catadmin" wrote:
> > Just an FYI. I tried creating a new job that contained the above 3 steps and
> > the Notify Operator (set with a fail precendence from the other three tasks)
> > for another user db. I hit save, then the X up in the right hand corner and
> > got the following error message:
> >
> > "Apply to target server failed for job 'MyJobName' "
> >
> > I did get this error message on the other job and wonder if maybe there's a
> > connection between this and the GUID message?
> >
> > Thanks,
> > Catadmin
> >
> > --
> > MCDBA, MCSA
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the back?
> > @.=)
> >
> >
> > "Catadmin" wrote:
> >
> > > Someone help me please. I'm confused.
> > >
> > > I've got a brand new Maintenance Plan which reorganizes indexes, clears out
> > > the MP history and updates DB stats. It refused to save with a schedule of
> > > once a week on Sunday at 1:00 a.m., but did save without a schedule (on
> > > demand).
> > >
> > > I have reopened the Maintenance Plan and tried to create a schedule. Every
> > > time I try to close out and save (X on the upper right), it gives me the
> > > Error: "GUID should contain 32 digits with 4 dashes
> > > (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)" with an OK button and no other
> > > information.
> > >
> > > What is going on? Does anyone know? Help would be appreciatedd since we're
> > > right on top of our official 2000-to-2005 server switch over.
> > >
> > > Thanks,
> > >
> > > Catadmin
> > > --
> > > MCDBA, MCSA
> > > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > > Microsoft pays the bills for the funny white jackets that tie in the back?
> > > @.=)
No comments:
Post a Comment