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

Re: Databases keep going suspect

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.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	Wed, 11 May 2011 23:51:42 +0200
Organization	Erland Sommarskog
Lines	28
Message-ID	<Xns9EE2F2BBE625FYazorman@127.0.0.1> (permalink)
References	<ea2bc881-0397-4046-ac96-8a2bbb32063a@r20g2000yqd.googlegroups.com> <Xns9EE12A299A4Yazorman@127.0.0.1> <ae395e72-c4f8-4b85-b3a0-31e5b90ad173@e21g2000vbz.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="23932"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/BMoaoccczVaj6OWmKNmMF"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:8yVLp1iKoKBVHFJKwD4xjH+Gt44=
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:325

Show key headers only | View raw

Admin Matt (admin.matthew@gmail.com) writes:
> The error logs show that the LDF file can't be accessed because it is
> being used by another process (event id: 17207). This process is no
> longer using the file by the time we can check out the problem. The
> event id always appears at night. We are now having the antivirus
> avoid scanning the LDF and MDF files and also we are turning off the
> Backup Exec software for now with the Data folder even though the
> errors normally appear before the backup even starts. Finally we are
> setting the problem database Auto Close option to False. I will post
> the results. It will probably take more than a week to know if the
> issue is actually fixed.

I've no idea what might be looking at your log file, but turning off 
autoclose should learn them to keep out.

Not that it is relevant to your, but I had some crappy backup software
running on my machine at home; it was something I got with the NAS. Fairly
often I would get errors about locked files. And this happened even in 
directories that were not included in the backup scheme. Eventually I 
got myself together and uninstalled.

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