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 Member]

1. Restore the database backup file.

2. If no backup is available, then run the following commands

ALTER DATABASE Databasename SET EMERGENCY
DBCC CHECKDB 'Databasename'
ALTER DATABASE Databasename SET SINGLE USER with ROLLBACK IMMEDIATE
DBCC CHECKDB 'Databasename, REPAIR_ALLOW_DATA_LOSS'
ALTER DATABASE Databasename SET MULTIUSER

Use third party tool which helps you to easily repair and recover database from suspect mode. http://www.sqlrecoverysoftware.net/blog/repair-database-from-suspect-mode.html