Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #312

Re: Databases keep going suspect

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Databases keep going suspect Admin Matt <admin.matthew@gmail.com> - 2011-05-09 08:27 -0700
  Re: Databases keep going suspect Erland Sommarskog <esquel@sommarskog.se> - 2011-05-10 00:00 +0200
    Re: Databases keep going suspect Admin Matt <admin.matthew@gmail.com> - 2011-05-11 10:16 -0700
      Re: Databases keep going suspect "Fred." <ghrno-google@yahoo.com> - 2011-05-11 10:44 -0700
      Re: Databases keep going suspect Erland Sommarskog <esquel@sommarskog.se> - 2011-05-11 23:51 +0200
      Re: Databases keep going suspect "shortcutter@googlemail.com" <shortcutter@googlemail.com> - 2011-05-12 03:48 -0700
        Re: Databases keep going suspect Admin Matt <admin.matthew@gmail.com> - 2011-05-12 10:24 -0700
          Re: Databases keep going suspect Admin Matt <admin.matthew@gmail.com> - 2011-05-20 06:43 -0700

csiph-web