asked on

SQL 2005 database error when trying to view properties

HI All, I am tryingt o look at the properties of a SQL 2005 Database ona customer site and I am egtting the following errors:
I have browsed sevral forums and none seem to fit the picture. Can anyone let me know the ebst path to take with this one?
thanks in advance
Craig
TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

Database 'CCMData' 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.4053&EvtSrc=MSSQLServer&EvtID=945&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

jogos

"cannot be opened due to inaccessible files or insufficient memory or disk space"

3 clear indications which you didn't counter, at least the last 2 should be easy verifyable

mrbungle50

ASKER

Update: The application is SQL 2005 Express in case that means anything at all and the database file is only 395MB in size.

mrbungle50

ASKER

Sorry just found your post... OK the DB size seems fine and the disk has ample space
I am looking into the file permissions
the sql access to logon to the managment GUI is through windows authentication as an administrator

ralmada

A few pointers:

1) Check if the database is set to Autogrow on.
2) Check if the account which is trying to access the database has enough permission to perform operation.
3) Make sure that .mdf and .ldf file are not marked as read only on operating system file system level.
http://blog.sqlauthority.com/2007/08/02/sql-server-fix-error-945-database-cannot-be-opened-due-to-inaccessible-files-or-insufficient-memory-or-disk-space-see-the-sql-server-error-log-for-details/

rk_india1

It is the common issue for DBA. It is happen due to some of the database no recovered correctly. To resolve the issue to take the database offline then bring it online then you can open the database properties safely.

ASKER CERTIFIED SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mrbungle50

ASKER

Thanks Guys sorry for t6he dleay, after reading the error messages I have recreated the database and started again. this was far more suitable solution as the data contained was not that vital.
Thanks again
Craig
MrBungle50