Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-27 : 08:12:29
|
| James writes "Here is the problem.....We have recently migrated our SQL Server DB to a new server (SQL 200 SP3 and in 2000 SP3) and while trying to run oone of the longer DTS jobs we are getting the following warning."SERVER BUSYThe action cannot be completed because the other program is busy. Choose 'switch to' to activate the busy program and correct the problem."At this point we do not have anything else running on the server but when we select 'Switch to' the start menu pops up. Retry seems to get us stuck since the error does not go away unless sql is ended. There seem to be not much difference between the old server and the new besides the fact that we were running on a trial version of sql and now we try to use the full version. We have no problems on the old sever with these jobs so we don't know what it could be.If you can, please shed some light on this error.Thanks in advance," |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-29 : 13:12:12
|
| Have you tried rebooting the server yet? How are you running the DTS job? In the designer or in SQLAgent jobs?Tara |
 |
|
|
|
|
|
Server Busy