Microsoft SQL Server, Error: 945

Question

Post reply

Microsoft SQL Server, Error: 945

Adam-393315

SSC Veteran

Points: 225
More actions
February 11, 2007 at 5:26 pm

#115518

Hi Everyone,
I am getting the strangest things happen with sql server 2005 standard that we never had when installed on our other servers with sql server express.
Basically we have over 600+ databases on an install and every day three or four of these databases will become unresponsive. When you go into the Studio Manager the little expansion + symbol next to the effected databases has dissappeared and when you go to view the properties of the database you get the following error.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Database 'usImpactChiropracticClinic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=945&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I have checked the memory and there is ample amounts available for the system to use. I have also checked if there is virus software running on the system that may be using the files that prevents sql server opening them but there isnt. I have also ran filemon to see what processes are using the files when this happens and it returns nothing.
Has anyone every had this issue before because it has us stumped and all we can do to regain the databases back is to reboot the server. Having to do this once or twice a day really isnt a long term solution. Any ideas please?
Cheers in advance

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

MohammedU SSCoach Points: 19644 More actions · Answer 1

See the following article..you may get the solution..

http://support.microsoft.com/kb/899436

MohammedU
Microsoft SQL Server MVP

malleswarareddy_m SSCertifiable Points: 5847 More actions · Answer 2

Hi,

i just restart the sql services.This worked fine for me.But this error no 945 show me thst insufficient meory.i check that there is lot of free space.then i restart the sql services

open run-->type..[services.msc]

then select sqlserver click on restart.

Malleswarareddy
I.T.Analyst
MCITP(70-451)

sivark1 SSCrazy Points: 2654 More actions · Answer 3

yes i too got same issue

then i restarted the agent servicese it works fine.

Silverfox SSC-Insane Points: 23150 More actions · Answer 4

Adam-393315 (2/11/2007)
Hi Everyone,
I am getting the strangest things happen with sql server 2005 standardthat we never had when installed on our other servers with sql server express.
Basically we have over 600+ databases on an install and every day three or four of these databases will become unresponsive. When you go into the Studio Manager the little expansion + symbol next to the effected databases has dissappeared and when you go to view the properties of the database you get the following error.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Database 'usImpactChiropracticClinic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=945&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I have checked the memory and there is ample amounts available for the system to use. I have also checked if there is virus software running on the system that may be using the files that prevents sql server opening them but there isnt. I have also ran filemon to see what processes are using the files when this happens and it returns nothing.
Has anyone every had this issue before because it has us stumped and all we can do to regain the databases back is to reboot the server. Having to do this once or twice a day really isnt a long term solution. Any ideas please?
Cheers in advance

The only thing that has not been mentioned is your build version, are you running on the latest service pack. what is the build version of your sql server.

this link will show the build versions

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

fqureshi786 Old Hand Points: 387 More actions · Answer 5

Check your errorlog and it will provide you additonal errors (like 9004) when you see 945 errors. You'll have to address those.

But it sounds like that you see this issue intermittently, which is strange, but look for more detailed message in the error log and it will tell you WHAT file it's not able to access. then you can check whether there's any kind of space issue on the disk or on the files themselves (like auto grow is not enabled or something).

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Please note: 4 year old thread.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass