SQL Server issues

[Former Member]

Hi All,

In SQL server mgmt studio I am finding this error

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

Additional information:

Database 'msdb' 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)

What might be the cause and How to solve this?

Regards,

Rupa Sarkar

[former_member186095]

Hi,

The 1st step to solve this issue is to restart the SQL server service. if not solved, try the solutions from one of these links:

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/da2142ad-c4db-40dc-8383-d4512...

http://blog.sqlauthority.com/2007/08/02/sql-server-fix-error-945-database-cannot-be-opened-due-to-in...

JimM