SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Server 2005 error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

matthisco
Starting Member

48 Posts

Posted - 02/11/2009 :  05:36:40  Show Profile  Reply with Quote
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

Sweden
30115 Posts

Posted - 02/11/2009 :  05:39:30  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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"
Go to Top of Page

matthisco
Starting Member

48 Posts

Posted - 02/11/2009 :  05:41:51  Show Profile  Reply with Quote
Great thanks, can you tell me how I can restart it?

Thanks again
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30115 Posts

Posted - 02/11/2009 :  05:44:45  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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"
Go to Top of Page

matthisco
Starting Member

48 Posts

Posted - 02/11/2009 :  05:49:29  Show Profile  Reply with Quote
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.exe
mmc.exe
winlogin.exe
shstat.exe
vmwareuser.exe
rdclip.exe
explorer.exe
ipdaterui.exe
tbmon.exe
csrss.exe

Do 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


Edited by - matthisco on 02/11/2009 05:51:52
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000