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

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

Databases keep going suspect

Show all headers | View raw

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'
GO

Back to comp.databases.ms-sqlserver | Previous | Next — 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