Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!
Maintenace Plan-T-log backup failed
Hi,
We have two different maintenance plans scheduled to take t-log backup for two different sets of DB's.Both the jobs are scheduled to run every 15 min's.
But these jobs are failing very often almost at same time.
Found following error messages in
SQL Server Log:
Error: Maintenance plan 'All ad-hoc plans'. B:\SQL_Backup\Backup\<t-lo
Windows Event Log:
Error: 60000 Severity: 10 State: 1 Error: Maintenance plan 'All ad-hoc plans'. ...
Could some one let me know the reason behind this..and how can i solve this issue.
Thanks,
We have two different maintenance plans scheduled to take t-log backup for two different sets of DB's.Both the jobs are scheduled to run every 15 min's.
But these jobs are failing very often almost at same time.
Found following error messages in
SQL Server Log:
Error: Maintenance plan 'All ad-hoc plans'. B:\SQL_Backup\Backup\<t-lo
Windows Event Log:
Error: 60000 Severity: 10 State: 1 Error: Maintenance plan 'All ad-hoc plans'. ...
Could some one let me know the reason behind this..and how can i solve this issue.
Thanks,
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
Right click your Maintenance plan and click View history which would give you the detailed explanation of your error..
Posting it would help..
Posting it would help..
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trial
Yes i did,
The backup step is successful for both the jobs but the Cleanup step is getting failed causing the jobs to get failed.
fyi
The cleanup step is set on two jobs but specified common folder. My understanding is that when both cleanup jobs starting at same time causing the step to fail. am i right?
The backup step is successful for both the jobs but the Cleanup step is getting failed causing the jobs to get failed.
fyi
The cleanup step is set on two jobs but specified common folder. My understanding is that when both cleanup jobs starting at same time causing the step to fail. am i right?
No.. Kindly check whether the folders specified in Cleanup task are correct or not..
if correct, then check whether you have appropriate permissions to those folders or not.
if correct, then check whether you have appropriate permissions to those folders or not.
yes we do.
Both cleanup steps in two different jobs point to same common folder "Backup". If there are no right permissions to this folder why the job fails some times and run suscessfully most of the time.
fyi
The backup folders are all present in this common folder so this is set as common in two clean up steps.
Thanks,
Both cleanup steps in two different jobs point to same common folder "Backup". If there are no right permissions to this folder why the job fails some times and run suscessfully most of the time.
fyi
The backup folders are all present in this common folder so this is set as common in two clean up steps.
Thanks,
>> If there are no right permissions to this folder why the job fails some times and run suscessfully most of the time.
Do you have two ways of executing that plan..
Any password expirations or reset like that.
Do you have two ways of executing that plan..
Any password expirations or reset like that.
Are you executing Maintenance plan only using the scheduled way..
Also check the password expiration policy of the user account under which this plan executes.
Also make whether the path is available all the time if it is a network path or shared path..
Also check the password expiration policy of the user account under which this plan executes.
Also make whether the path is available all the time if it is a network path or shared path..
is that for wittyslogan or rrjegan17?
I'm asking about timestamps just incase the 2 jobs ARE trying to delete same file at the same time.
Have you run profiler by the way to see where the job fails exactly?
I'm asking about timestamps just incase the 2 jobs ARE trying to delete same file at the same time.
Have you run profiler by the way to see where the job fails exactly?
Are you executing Maintenance plan only using the scheduled way..
>> Yes it is scheduled to run every 15 min.
Also check the password expiration policy of the user account under which this plan executes.
>> No, there isn't any password policy set have sys admin privileges.
Also make whether the path is available all the time if it is a network path or shared path
>> It is local drive, not a share.
>> Yes it is scheduled to run every 15 min.
Also check the password expiration policy of the user account under which this plan executes.
>> No, there isn't any password policy set have sys admin privileges.
Also make whether the path is available all the time if it is a network path or shared path
>> It is local drive, not a share.
wittyslogan,
Yes it looks the jobs are failing when the cleanup step start same time, timestamp as below when two jobs failed,
Job1:: 3/24/2010 3:31:15 AM
Job2:: 3/24/2010 3:31:07 AM
Have you run profiler by the way to see where the job fails exactly?
I'm not sure that running profiler will give information on this issue.
Thanks,
Yes it looks the jobs are failing when the cleanup step start same time, timestamp as below when two jobs failed,
Job1:: 3/24/2010 3:31:15 AM
Job2:: 3/24/2010 3:31:07 AM
Have you run profiler by the way to see where the job fails exactly?
I'm not sure that running profiler will give information on this issue.
Thanks,
>> Yes it looks the jobs are failing when the cleanup step start same time, timestamp as below when two jobs failed
There should not be any issue in having both tasks running at the same time..
There should not be any issue in having both tasks running at the same time..
When I mentioned the time stamp I meant do the files get given a timestemp eg. backup_file_db_23031017013
Also, is it not worth having a go with profiler since it does write sql statements and we can then at least rule it out as a help in this case?
Also there is probably a crossover as we are all typing quite fast but do you have the error from maintenance plan history
Cheers
wittyslogan,
Yes we have the same timestamp setting to the backup file.
are the backups being cleaned up?
>> Yes they are getting cleaned up in the next successful run.
Thanks :)
Yes we have the same timestamp setting to the backup file.
are the backups being cleaned up?
>> Yes they are getting cleaned up in the next successful run.
Thanks :)
I have a question here,
In the cleanup task window there is one check box option set "Include first-level subfolders" in File Location tab, What does it exactly refer to?
In the cleanup task window there is one check box option set "Include first-level subfolders" in File Location tab, What does it exactly refer to?
what this means is that if you have a folder called "backups" and in you have the folders for the backups of databases 1 to 3 then it will go in and clean up the subfolders 1 to 3 without you having to actually write clean up 1 to 3.
If this isn't ticked then it will only clean up the backups in the folder "backups" and won't look in any subfolders.
If this isn't ticked then it will only clean up the backups in the folder "backups" and won't look in any subfolders.
wittyslogan,
We created this Maintenance Plan using Quest Litespeed, So it show up with following error, I shld have mention this earlier. I'm sorry about that.
There are error messages in it. It is beacus of the two clean up steps as i think,
It says in the error message
Error delete file: "\\Backup\\temp_TLog_20100
Found same message in other maintenance job history as well.
Thanks
We created this Maintenance Plan using Quest Litespeed, So it show up with following error, I shld have mention this earlier. I'm sorry about that.
There are error messages in it. It is beacus of the two clean up steps as i think,
It says in the error message
Error delete file: "\\Backup\\temp_TLog_20100
Found same message in other maintenance job history as well.
Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server
From novice to tech pro — start learning today.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.