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-log filr name>.TRN ...

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,
parpaaAsked:
Who is Participating?
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.

wittysloganCommented:
have you looked in maintenance plan history?
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Right click your Maintenance plan and click View history which would give you the detailed explanation of your error..
Posting it would help..
0

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
parpaaAuthor Commented:
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?
0
The Ultimate Tool Kit for Technolgy Solution Provi

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!

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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.
0
parpaaAuthor Commented:
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,
0
wittysloganCommented:
are the backups date/time stamped?
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> 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.
0
parpaaAuthor Commented:
Sorry, I'm not clear with your quetsion.

Thanks
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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..
0
wittysloganCommented:
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?
0
parpaaAuthor Commented:
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.
0
wittysloganCommented:
what is the exact error that you see in maintenance plan history?
0
parpaaAuthor Commented:
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,
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> 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..
0
parpaaAuthor Commented:
wittyslogan,

are the backups date/time stamped?
 >>yes

Thanks,
0
wittysloganCommented:

When I mentioned the time stamp I meant do the files get given a timestemp eg. backup_file_db_230310170134000.trn?

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
0
wittysloganCommented:
are the backups being cleaned up?
0
parpaaAuthor Commented:
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 :)
0
wittysloganCommented:
but do you have to error from the maintenance plan history?
0
parpaaAuthor Commented:
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?


0
wittysloganCommented:
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.
0
parpaaAuthor Commented:
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_201003200330.TRN". Error: "The system cannot find the file specified"

Found same message in other maintenance job history as well.

Thanks
0
parpaaAuthor Commented:
Thanks a lot guys for your support.

Cheers :)
0
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.