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 |
|
matthisco
Starting Member
48 Posts |
 Posted - 2009-02-11 : 05:36:40
|
| I keep getting the error below when I try and open or create a new db.Can anyone help?'Sql server is busy, if you keep encountering this problem please contact microsoft.' |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-11 : 05:39:30
|
And Microsoft told you to ask us?  Just joking...If you think you have waited enough, and the creation of the new database still fails, the SQL Server is either busy with something, or SSMS has hung.Try restart SSMS.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
matthisco
Starting Member
48 Posts |
Posted - 2009-02-11 : 05:41:51
|
| Great thanks, can you tell me how I can restart it?Thanks again |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-11 : 05:44:45
|
Right click taskbar and choose Task Manager.Then select Management Studio and kill the application.You may even have to go to next tab and choose ssms there and kill process.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
matthisco
Starting Member
48 Posts |
Posted - 2009-02-11 : 05:49:29
|
| Thank for your reply.I've logged into my webserver and clicked on the task bar, I only see IIS running as an application.I can't see a process called sql server running. I have:taskmgr.exemmc.exewinlogin.exeshstat.exevmwareuser.exerdclip.exeexplorer.exeipdaterui.exetbmon.execsrss.exeDo I need to restart the service on my webserver? If so which one? There are a few sql server services running.Can you please advise?Thanks again |
|
|
|
|
|
|
SQL Server 2005 error