Sunday, February 19, 2012

DB Maint Plan running indefinetly

DB backup and DB log backup part of DB maint plan still running.
I checked the backup folders and it seems like it only missed one db all
other db's have both backups.
I tried to backup the db and log from query anazyler and it worked fine.
When i refresh jobs and check current activity these 2 jobs still running.
Did anyone ever come across this problem?
ThanksTHE JOBS STARTED THIS MORNING.|||How big are the databases?
Where are you writing the backup file to, local drive, network share,
tape?
What does perfmon tell you, i.e. Avg Disk Queue Length, Device
Throughput Bytes/sec for those backup devices?
Does sp_who2 show anything blocking the backup processes?
You're going to have to do some diagnosis to determine what's going on,
there are certain basic things to check.|||Tracy thanks for responding.
Databases are small. biggest db is 1gigs.
It's writing to a local E:\Backup\ Drive.
I had to stop the jobs.
sp_who2 right now says this for both jobs:
130 RUNNABLE NT AUTHORITY\SYSTEM SQL2K . master
KILLED/ROLLBACK SQLAgent - TSQL JobStep (Job
0xBB38EE1DBF4A2541A1DEC606645B5EEE : Step 1) 130
But these jobs will start again tonight and tomorrow morning i will turn on
the perf mon to catch that info.
Do you think something was blocking the process?
What kind of info should i expect from perf mon or sp_who2 if the jobs keep
on running tomorrow?
Thanks
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1149021576.867321.51370@.i39g2000cwa.googlegroups.com...
> How big are the databases?
> Where are you writing the backup file to, local drive, network share,
> tape?
> What does perfmon tell you, i.e. Avg Disk Queue Length, Device
> Throughput Bytes/sec for those backup devices?
> Does sp_who2 show anything blocking the backup processes?
> You're going to have to do some diagnosis to determine what's going on,
> there are certain basic things to check.
>

No comments:

Post a Comment