Microsoft sql server 2008 error 945 msdb

Please, provide the error message. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log. Add a comment. Active Oldest Votes. Improve this answer. Ben Thul Ben Thul The Overflow Blog.

Podcast Making Agile work for data science. So pls tell me reasons of database on offline mode and suspect mode. I am facing this issue at one of my clients system. See the SQL Server errorlog for details. Microsoft SQL Server,. Then also connects to Database. But clients databases are not visible. They are able to do data operation through applications from other PCs. Issue is only on accessing from SSMS.

Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure.

Check the error log for more information. If Log file corrupted, then what we have to do? An exception occurred while executing a Transact-SQL statement or batch.

One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.

If this is an existing database, the file may be corrupted and should be restored from a backup. Database 'Basketball' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. It may be from a different database or the log may have been rebuilt previously.

Cannot show requested dialog.