June 22, 2010 at 10:58 am
SQL server with a small DB. I created a maintenance plan to do a full backup. When I execute the plan it starts executing, status is In Progress, but nothing ever happens. No errors, no logs are created, no folders are created, nothing. It just runs for a long time.
I tried creating and running this various ways, using the wizards or manually, executing from the maintenance plan and by running the SQL Server Agent Job. Nothing appears to occur at all. It's a small DB it should not take a long time to backup. I've restarted SQL service and the SQL server agent with no better luck. I've never had issues with backups on other SQL servers, or at the least I would get an error which tells me what needs fixing.
SQL 2005
9.00.4053.00SP3Standard Edition (64-bit)
Windows Server 2003 std x64
I saw another post which seemed similar, and I was going to post, there but the issues may be different so I didn't want to hijack that thread.
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 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply