June 22, 2010 at 7:54 pm
How big are the databases being backed up?
Where are you seeing the in progress status? Is it the job viewer? If so, have you tried refreshing the job viewer?
Are there other tasks in the maintenance plan? If so, what tasks and how are they connected?
And, have you checked the activity monitor to see what is actually processing/running and verify that there is nothing blocking the process?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 23, 2010 at 5:38 am
Alex Laime (6/22/2010)
I tried creating and running this various ways, using the wizards or manually
Have you tried through scripting ? addtionally is there any mgmt window opened ( using same DB) although there is no chance of that but still you can check that.
run Sp_lock and sp_who2 , it will give you details where that Db is being used.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply