87847ef6   
   From: esquel@sommarskog.se   
      
   Admin Matt (admin.matthew@gmail.com) writes:   
   > We have a couple of databases on 2 different MS SQL 2005 Express   
   > servers that every week or so will be unaccessible. When we try to   
   > access the database from SQL Management Studio we get an error 945. If   
   > we run the code below is says the database is suspect. If we run   
   > "alter database [database name] set offline" then "alter database   
   > [database name] set online" the database will work again for a week or   
   > so. If we run DBCC CHECKDB ('DB Name') WITH NO_INFOMSGS there are no   
   > errors with the database reported. Any ideas of what is going on?   
   >   
   >   
   > SELECT DATABASEPROPERTYEX('Database Name', 'Status')   
   > DatabaseStatus_DATABASEPROPERTYEX   
   > GO   
   > SELECT state_desc DatabaseStatus_sysDatabase   
   > FROM sys.databases   
   > WHERE name = 'Database Name'   
      
   Message 945 reads "Database '%.*ls' cannot be opened due to inaccessible   
   files or insufficient memory or disk space.  See the SQL Server errorlog for   
   details."   
      
   Have you checked the SQL Server errorlog for messages?   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)