Art of Software, Craft of Hardware

“Software is a great combination between artistry and engineering. When you finally get done and get to appreciate what you have done it is like a part of yourself that you've put together. I think a lot of the people here feel that way.” -- Bill Gates

Showing posts with label Tips MSSQL. Show all posts
Showing posts with label Tips MSSQL. Show all posts

Wednesday, February 3, 2010

SQL SERVER - Fix Error 945

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


I faced this issue twice in the last couple of weeks. If any of you face this, try the following first:

select databaseproperty('','isShutdown')

alter database set offline

alter database set online

If the above does not work. Please go ahead with your Googling.

‎

Read more!

Posted by Unknown at 11:16 PM 0 comments  

Labels:

Subscribe to: Posts (Atom)