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

Re: Databases keep going suspect

Path	csiph.com!x330-a1.tempe.blueboxinc.net!aioe.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Databases keep going suspect
Date	Tue, 10 May 2011 00:00:58 +0200
Organization	Erland Sommarskog
Lines	31
Message-ID	<Xns9EE12A299A4Yazorman@127.0.0.1> (permalink)
References	<ea2bc881-0397-4046-ac96-8a2bbb32063a@r20g2000yqd.googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx02.eternal-september.org; posting-host="DD6dU+BfJNjsjSP4/K/V7w"; logging-data="28907"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18GQjVG16Lbg79quX+llvrz"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:QNaaOcPXdxgclca5OXmakjNTk+Y=
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:312

Show key headers only | 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