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

Re: Databases keep going suspect

From	Admin Matt <admin.matthew@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Databases keep going suspect
Date	2011-05-11 10:16 -0700
Organization	http://groups.google.com
Message-ID	<ae395e72-c4f8-4b85-b3a0-31e5b90ad173@e21g2000vbz.googlegroups.com> (permalink)
References	<ea2bc881-0397-4046-ac96-8a2bbb32063a@r20g2000yqd.googlegroups.com> <Xns9EE12A299A4Yazorman@127.0.0.1>

Show all headers | View raw

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.

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