Hello, I've been having some problems with my Maintainance plan in SQL Server 2000. It will occationally quit working for days at a time. Sometimes it will do everything but back up the databases, and it steadfastly refuses to delete log backups over 6 weeks old (as I have asked it to). Anybody have any advice for me? Please, someone tell me the only thing to do is to take it out in the parking lot and kick it around. ThanksThere isn't anything else on the server (Win 2000), and its configured to stay powered up all the time. Theres also no significant traffic when its configured to run.
Thanks|||I would like to know if there is any other way of allowing a user to be able to run maintenance plan or create databases without being sysAdmin.|||GRANT DUMP DATABASE , DUMP TRANSACTION TO <user_name>
go
exec sp_addsrvrolemember <user_name>, dbcreator
go|||http://support.microsoft.com/default.aspx?scid=kb;en-us;288577 KBA to troubleshoot Maint.plans.
Showing posts with label maintainance. Show all posts
Showing posts with label maintainance. Show all posts
Wednesday, March 21, 2012
Monday, March 19, 2012
Maintaintance plan error
I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
am creating new maintainance plan ,at the end when i click finish button of
the wizard,message i am getting is "one or more arguments are invalid",please
reply me what is the problem asap.
Thanks
Rupesh
It looks like some other people have been experiencing this problem. One
thing that has been suggested in another thread is to assure that you have
SP2 also of Management Studio.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1823734&SiteID=1
If you're interested in an alternative to the Maintenance Plans you could
have a look at a stored procedure based solution that I've made.
http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
Ola Hallengren
http://ola.hallengren.com
"Rupesh Mondal" wrote:
> I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
> am creating new maintainance plan ,at the end when i click finish button of
> the wizard,message i am getting is "one or more arguments are invalid",please
> reply me what is the problem asap.
> Thanks
> Rupesh
|||Thank you for the help, my sa password was blank thats why it was not working,
now it is working fine.
Rupesh Mondal.
"Ola Hallengren" wrote:
[vbcol=seagreen]
> It looks like some other people have been experiencing this problem. One
> thing that has been suggested in another thread is to assure that you have
> SP2 also of Management Studio.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1823734&SiteID=1
> If you're interested in an alternative to the Maintenance Plans you could
> have a look at a stored procedure based solution that I've made.
> http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> Ola Hallengren
> http://ola.hallengren.com
>
> "Rupesh Mondal" wrote:
am creating new maintainance plan ,at the end when i click finish button of
the wizard,message i am getting is "one or more arguments are invalid",please
reply me what is the problem asap.
Thanks
Rupesh
It looks like some other people have been experiencing this problem. One
thing that has been suggested in another thread is to assure that you have
SP2 also of Management Studio.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1823734&SiteID=1
If you're interested in an alternative to the Maintenance Plans you could
have a look at a stored procedure based solution that I've made.
http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
Ola Hallengren
http://ola.hallengren.com
"Rupesh Mondal" wrote:
> I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
> am creating new maintainance plan ,at the end when i click finish button of
> the wizard,message i am getting is "one or more arguments are invalid",please
> reply me what is the problem asap.
> Thanks
> Rupesh
|||Thank you for the help, my sa password was blank thats why it was not working,
now it is working fine.
Rupesh Mondal.
"Ola Hallengren" wrote:
[vbcol=seagreen]
> It looks like some other people have been experiencing this problem. One
> thing that has been suggested in another thread is to assure that you have
> SP2 also of Management Studio.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1823734&SiteID=1
> If you're interested in an alternative to the Maintenance Plans you could
> have a look at a stored procedure based solution that I've made.
> http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> Ola Hallengren
> http://ola.hallengren.com
>
> "Rupesh Mondal" wrote:
Maintaintance plan error
I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
am creating new maintainance plan ,at the end when i click finish button of
the wizard,message i am getting is "one or more arguments are invalid",please
reply me what is the problem asap.
Thanks
RupeshIt looks like some other people have been experiencing this problem. One
thing that has been suggested in another thread is to assure that you have
SP2 also of Management Studio.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1823734&SiteID=1
If you're interested in an alternative to the Maintenance Plans you could
have a look at a stored procedure based solution that I've made.
http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
Ola Hallengren
http://ola.hallengren.com
"Rupesh Mondal" wrote:
> I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
> am creating new maintainance plan ,at the end when i click finish button of
> the wizard,message i am getting is "one or more arguments are invalid",please
> reply me what is the problem asap.
> Thanks
> Rupesh|||Thank you for the help, my sa password was blank thats why it was not working,
now it is working fine.
Rupesh Mondal.
"Ola Hallengren" wrote:
> It looks like some other people have been experiencing this problem. One
> thing that has been suggested in another thread is to assure that you have
> SP2 also of Management Studio.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1823734&SiteID=1
> If you're interested in an alternative to the Maintenance Plans you could
> have a look at a stored procedure based solution that I've made.
> http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> Ola Hallengren
> http://ola.hallengren.com
>
> "Rupesh Mondal" wrote:
> > I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
> > am creating new maintainance plan ,at the end when i click finish button of
> > the wizard,message i am getting is "one or more arguments are invalid",please
> > reply me what is the problem asap.
> >
> > Thanks
> > Rupesh
am creating new maintainance plan ,at the end when i click finish button of
the wizard,message i am getting is "one or more arguments are invalid",please
reply me what is the problem asap.
Thanks
RupeshIt looks like some other people have been experiencing this problem. One
thing that has been suggested in another thread is to assure that you have
SP2 also of Management Studio.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1823734&SiteID=1
If you're interested in an alternative to the Maintenance Plans you could
have a look at a stored procedure based solution that I've made.
http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
Ola Hallengren
http://ola.hallengren.com
"Rupesh Mondal" wrote:
> I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
> am creating new maintainance plan ,at the end when i click finish button of
> the wizard,message i am getting is "one or more arguments are invalid",please
> reply me what is the problem asap.
> Thanks
> Rupesh|||Thank you for the help, my sa password was blank thats why it was not working,
now it is working fine.
Rupesh Mondal.
"Ola Hallengren" wrote:
> It looks like some other people have been experiencing this problem. One
> thing that has been suggested in another thread is to assure that you have
> SP2 also of Management Studio.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1823734&SiteID=1
> If you're interested in an alternative to the Maintenance Plans you could
> have a look at a stored procedure based solution that I've made.
> http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> Ola Hallengren
> http://ola.hallengren.com
>
> "Rupesh Mondal" wrote:
> > I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
> > am creating new maintainance plan ,at the end when i click finish button of
> > the wizard,message i am getting is "one or more arguments are invalid",please
> > reply me what is the problem asap.
> >
> > Thanks
> > Rupesh
Maintainance Plan - Transaction Log Backups Not Deleted
Hi
Ive got a Maintainance Plan set up for all my databases.
The Database backup part works fine but I have a problem
with the Transaction log backup. I have set it to delete
old TRN files after 4 days. However it does not to this.
It creates a new TRN file, but does not delete the old
ones. I have looked in the job history - it just says the
job failed. I have checked the NTFS permissions - they
seem ok. Any ideas
TIA
RobProblem is that one of your databases recovery model is
set to simple. (microsoft knowledge base article 303292)
go to enterprise manager| click down to databases| right
click on each database in your maintenance plan | select
properties| select options| each one should NOT be simple
select either full or bulk
>--Original Message--
>Hi
>Ive got a Maintainance Plan set up for all my databases.
>The Database backup part works fine but I have a problem
>with the Transaction log backup. I have set it to delete
>old TRN files after 4 days. However it does not to this.
>It creates a new TRN file, but does not delete the old
>ones. I have looked in the job history - it just says
the
>job failed. I have checked the NTFS permissions - they
>seem ok. Any ideas
>TIA
>Rob
>.
>|||You pretty much just get that generic message when you use
the maintenance plans. To find the specific errors, you need
to go to the maintenance plans, right click on the plan that
is failing and select Database Maintenance Plan History.
The problem with deleting the backups xx days old is most
likely related to one of the issues that Allan Mitchell
listed for you in his post - permissions or a sharing
violation.
-Sue
On 22 Sep 2003 04:36:22 -0700, rss@.abasoft.co.uk (Rob Smith)
wrote:
>Thanks for that tip but, each database was set to Full
>In the step detail in job history I get this
>sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
>Rob
>
>"bob schwartz" <robtschwartz@.sbcglobal.net> wrote in message news:<01c801c37c7f$411100b0$a401280a@.phx.gbl>...
>> Problem is that one of your databases recovery model is
>> set to simple. (microsoft knowledge base article 303292)
>> go to enterprise manager| click down to databases| right
>> click on each database in your maintenance plan | select
>> properties| select options| each one should NOT be simple
>> select either full or bulk
>>|||I had tried Allans advice, but it didnt seem to make a difference who
was running it. In the end I have got it working by going into SQL
Agent/Jobs/Transaction Log Backup/Properties/Steps and changing the
database from master to one of my user DBs. This ran ok with no errors
and removed the old files.
Thanks to everyone who helped with this
Rob
Sue Hoegemeier <Sue_H@.nomail.please> wrote in message news:<8n2vmvk74vhupjjfj9h96lrjpn0kcsvvd0@.4ax.com>...
> You pretty much just get that generic message when you use
> the maintenance plans. To find the specific errors, you need
> to go to the maintenance plans, right click on the plan that
> is failing and select Database Maintenance Plan History.
> The problem with deleting the backups xx days old is most
> likely related to one of the issues that Allan Mitchell
> listed for you in his post - permissions or a sharing
> violation.
> -Sue
> On 22 Sep 2003 04:36:22 -0700, rss@.abasoft.co.uk (Rob Smith)
> wrote:
> >Thanks for that tip but, each database was set to Full
> >
> >In the step detail in job history I get this
> >
> >sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
> >
> >Rob
> >
> >
> >"bob schwartz" <robtschwartz@.sbcglobal.net> wrote in message news:<01c801c37c7f$411100b0$a401280a@.phx.gbl>...
> >> Problem is that one of your databases recovery model is
> >> set to simple. (microsoft knowledge base article 303292)
> >> go to enterprise manager| click down to databases| right
> >> click on each database in your maintenance plan | select
> >> properties| select options| each one should NOT be simple
> >> select either full or bulk
> >>
> >>
Ive got a Maintainance Plan set up for all my databases.
The Database backup part works fine but I have a problem
with the Transaction log backup. I have set it to delete
old TRN files after 4 days. However it does not to this.
It creates a new TRN file, but does not delete the old
ones. I have looked in the job history - it just says the
job failed. I have checked the NTFS permissions - they
seem ok. Any ideas
TIA
RobProblem is that one of your databases recovery model is
set to simple. (microsoft knowledge base article 303292)
go to enterprise manager| click down to databases| right
click on each database in your maintenance plan | select
properties| select options| each one should NOT be simple
select either full or bulk
>--Original Message--
>Hi
>Ive got a Maintainance Plan set up for all my databases.
>The Database backup part works fine but I have a problem
>with the Transaction log backup. I have set it to delete
>old TRN files after 4 days. However it does not to this.
>It creates a new TRN file, but does not delete the old
>ones. I have looked in the job history - it just says
the
>job failed. I have checked the NTFS permissions - they
>seem ok. Any ideas
>TIA
>Rob
>.
>|||You pretty much just get that generic message when you use
the maintenance plans. To find the specific errors, you need
to go to the maintenance plans, right click on the plan that
is failing and select Database Maintenance Plan History.
The problem with deleting the backups xx days old is most
likely related to one of the issues that Allan Mitchell
listed for you in his post - permissions or a sharing
violation.
-Sue
On 22 Sep 2003 04:36:22 -0700, rss@.abasoft.co.uk (Rob Smith)
wrote:
>Thanks for that tip but, each database was set to Full
>In the step detail in job history I get this
>sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
>Rob
>
>"bob schwartz" <robtschwartz@.sbcglobal.net> wrote in message news:<01c801c37c7f$411100b0$a401280a@.phx.gbl>...
>> Problem is that one of your databases recovery model is
>> set to simple. (microsoft knowledge base article 303292)
>> go to enterprise manager| click down to databases| right
>> click on each database in your maintenance plan | select
>> properties| select options| each one should NOT be simple
>> select either full or bulk
>>|||I had tried Allans advice, but it didnt seem to make a difference who
was running it. In the end I have got it working by going into SQL
Agent/Jobs/Transaction Log Backup/Properties/Steps and changing the
database from master to one of my user DBs. This ran ok with no errors
and removed the old files.
Thanks to everyone who helped with this
Rob
Sue Hoegemeier <Sue_H@.nomail.please> wrote in message news:<8n2vmvk74vhupjjfj9h96lrjpn0kcsvvd0@.4ax.com>...
> You pretty much just get that generic message when you use
> the maintenance plans. To find the specific errors, you need
> to go to the maintenance plans, right click on the plan that
> is failing and select Database Maintenance Plan History.
> The problem with deleting the backups xx days old is most
> likely related to one of the issues that Allan Mitchell
> listed for you in his post - permissions or a sharing
> violation.
> -Sue
> On 22 Sep 2003 04:36:22 -0700, rss@.abasoft.co.uk (Rob Smith)
> wrote:
> >Thanks for that tip but, each database was set to Full
> >
> >In the step detail in job history I get this
> >
> >sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
> >
> >Rob
> >
> >
> >"bob schwartz" <robtschwartz@.sbcglobal.net> wrote in message news:<01c801c37c7f$411100b0$a401280a@.phx.gbl>...
> >> Problem is that one of your databases recovery model is
> >> set to simple. (microsoft knowledge base article 303292)
> >> go to enterprise manager| click down to databases| right
> >> click on each database in your maintenance plan | select
> >> properties| select options| each one should NOT be simple
> >> select either full or bulk
> >>
> >>
maintainance
I have a SQL server database application,
I just wnated to know that may I maintain the system while user use the
sysetm?
Should I maintain the system while all user off line?
Any information is great appreciated,Hi
It depends on what you are doing, but usually if you can schedule
maintenance when the system is quiet/down it will have less impact. Using
SQL Agent you can schedule your maintainance tasks for quiet times
John
"Souris" <Souris@.discussions.microsoft.com> wrote in message
news:9D26D4FF-1404-4E34-B19D-6DF86A34865D@.microsoft.com...
>I have a SQL server database application,
> I just wnated to know that may I maintain the system while user use the
> sysetm?
> Should I maintain the system while all user off line?
> Any information is great appreciated,
>|||As John said, it depends on the action you want to perform. If you have a
24/7 database you sure have no time slot to do a cold backup ;-). But as
John said, i wouldt places IO-based Activity (rebuilding of indexes) in the
primary processing time. If you have any questions for the details of your
actions you want to perform, do not hesitate to ask.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Souris" <Souris@.discussions.microsoft.com> schrieb im Newsbeitrag
news:9D26D4FF-1404-4E34-B19D-6DF86A34865D@.microsoft.com...
>I have a SQL server database application,
> I just wnated to know that may I maintain the system while user use the
> sysetm?
> Should I maintain the system while all user off line?
> Any information is great appreciated,
>
I just wnated to know that may I maintain the system while user use the
sysetm?
Should I maintain the system while all user off line?
Any information is great appreciated,Hi
It depends on what you are doing, but usually if you can schedule
maintenance when the system is quiet/down it will have less impact. Using
SQL Agent you can schedule your maintainance tasks for quiet times
John
"Souris" <Souris@.discussions.microsoft.com> wrote in message
news:9D26D4FF-1404-4E34-B19D-6DF86A34865D@.microsoft.com...
>I have a SQL server database application,
> I just wnated to know that may I maintain the system while user use the
> sysetm?
> Should I maintain the system while all user off line?
> Any information is great appreciated,
>|||As John said, it depends on the action you want to perform. If you have a
24/7 database you sure have no time slot to do a cold backup ;-). But as
John said, i wouldt places IO-based Activity (rebuilding of indexes) in the
primary processing time. If you have any questions for the details of your
actions you want to perform, do not hesitate to ask.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Souris" <Souris@.discussions.microsoft.com> schrieb im Newsbeitrag
news:9D26D4FF-1404-4E34-B19D-6DF86A34865D@.microsoft.com...
>I have a SQL server database application,
> I just wnated to know that may I maintain the system while user use the
> sysetm?
> Should I maintain the system while all user off line?
> Any information is great appreciated,
>
Subscribe to:
Posts (Atom)