September 16, 2010 at 7:16 pm
Hi Folks
I thought I had asked this before but cannot seem to find it.
Anyway I am really getting frustrated with this "is busy" error everytime I save a Maint Plan in SQL Server 2005 (64-bit) on a 64-bit Windows 2003 R2 Server.
Does anyone know how to resolve this issue ?
Thanks
Jim
September 17, 2010 at 3:44 am
Unfortunately it looks as though this is one of those things you just need to live with.
This post from MSDN should provide a little more insight ...
I have also noticed this message when using the designer in BIDS and other Visual Studio environments. In my opinion it is better to be informed than just have things freeze up like the good old days of Enterprise Manager.
** EDIT ** Ignore my post. I missed that you were looking for a solution, not an explantion. Sorry ** EDIT **
September 17, 2010 at 8:28 am
What service pack are you running?
September 17, 2010 at 10:46 am
This is an annoying bug (in my opinion) that has a non-traditional fix. If you are designing, which it sounds like you are and it hangs with the "busy" sign, right click the Sql server management studio in the Windows Task Bar. Thats it... It works for me when Sql server says its busy while editing a Diagram
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
September 17, 2010 at 11:55 am
Now that's an interesting fix... I'll have to remember it and see if it works the next time I come across that issue.
I don't use the Designer much though, so rarely run across the problem.
September 17, 2010 at 12:04 pm
I can't explain it, as I stated, but I know it works.
Some times we just don't need to ask why, just know that it works.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
September 20, 2010 at 9:45 am
Hi Brandie
I am on SP3
Jim
September 20, 2010 at 9:46 am
Thanks Everyone for the assist
Jim
September 20, 2010 at 10:15 am
Jim,
Did Chris's solution work for you? Or are you still having the problem?
September 20, 2010 at 10:18 am
I was curious but didn't want to bother him. But now that you have asked, my curiousity is piqued.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
September 21, 2010 at 2:24 pm
Hi Brandie
have not tried it yet
let me see and get back to you
Jim
September 21, 2010 at 2:45 pm
H IBrandie
right-clicking on
Sql server management studio in the Windows Task Bar
DID NOT WORK for me doing these twp tasks
made several MP changes and saved (most saved without busy message)
made several rename changes of MP (about 50/50 getting busy msg)
Jim
September 22, 2010 at 5:37 am
Okay, I'm going to ask again. What service pack (and version) of SQL Server are you running?
EDIT: And how much RAM are you running on the machine you're working from? Also check the Paging File size. Post both here.
September 22, 2010 at 9:19 am
Brandie
Your previous question(s) were answered above but I will add it again as well as the other requests:
OS:
Microsoft Windows Server 2003 R2
Enterprise x64 Edition
Service Pack 2
Quad-Core AMD Opteron
Processor 2356
2.30 GHz 16.0 GB of RAM
SQL Server:
SQL Server 2005
Microsoft SQL Server Developer Edition (64-bit)9.0.4053 SP3
SSMS settings:
Minimum server memoey [in MB]: 12288
Maximum server memory [in MB]: 12288
Page File:
Page File: Available: 24,576 MB
Jim
September 22, 2010 at 11:45 am
JC-3113 (9/22/2010)
BrandieYour previous question(s) were answered above but I will add it again as well as the other requests:
You didn't have service pack in there. I was thinking it might be an SP issue (there was a maint. plan issue with SP1), but you're upgraded past that point. And it's not a paging file issue, which was my next thought.
What do the plans that are "busy" have in common? Is there a specific task in each of them that's not in the plans that are saving correctly?
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply