Home
|
Weblogs
|
Forums
|
SQL Server Links
Search:
Active Forum Topics
|
Popular Articles
|
All Articles by Tag
|
SQL Server Books
|
About
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
Topic
matthisco
Starting Member
48 Posts
Posted - 02/11/2009 : 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
Sweden
29138 Posts
Posted - 02/11/2009 : 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 - 02/11/2009 : 05:41:51
Great thanks, can you tell me how I can restart it?
Thanks again
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts
Posted - 02/11/2009 : 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 - 02/11/2009 : 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.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
Topic
New Topic
Reply to Topic
Printer Friendly
Jump To:
Select Forum
General SQL Server Forums
New to SQL Server Programming
New to SQL Server Administration
Script Library
Data Corruption Issues
Database Design and Application Architecture
SQL Server 2012 Forums
Transact-SQL (2012)
SQL Server Administration (2012)
SSIS and Import/Export (2012)
Analysis Server and Reporting Services (2012)
Replication (2012)
Availability Groups and DR (2012)
Other SQL Server 2012 Topics
SQL Server 2008 Forums
Transact-SQL (2008)
SQL Server Administration (2008)
SSIS and Import/Export (2008)
High Availability (2008)
Replication (2008)
Analysis Server and Reporting Services (2008)
Other SQL Server 2008 Topics
SQL Server 2005 Forums
Transact-SQL (2005)
SQL Server Administration (2005)
.NET Inside SQL Server (2005)
SSIS and Import/Export (2005)
Service Broker (2005)
Replication (2005)
High Availability (2005)
Analysis Server and Reporting Services (2005)
Express Edition and Compact Edition (2005)
Other SQL Server Topics (2005)
SQL Server 2000 Forums
SQL Server Development (2000)
SQL Server Administration (2000)
Import/Export (DTS) and Replication (2000)
Transact-SQL (2000)
Analysis Services (2000)
MSDE (2000)
Development Tools
ASP.NET
Reporting Services Development
Other Development Tools
Site Related Forums
Site Related Discussions
Article Discussion
Poll Discussion
The Yak Corral
Other Forums
SQL Server 6.5 \ SQL Server 7.0
Other Topics
MS Access
ClearTrace Support Forum
Old Forums
CLOSED - General SQL Server
CLOSED - SQL Server 2005/Yukon
--------------------
Home
Active Topics
Frequently Asked Questions
Member Information
Search Page
SQL Server Forums
© 2000-2009 SQLTeam Publishing, LLC
This page was generated in 0.11 seconds.
SQL Server 2005 error
Posted - 02/11/2009 : 05:36:40
