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

Re: Databases keep going suspect

From	"shortcutter@googlemail.com" <shortcutter@googlemail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Databases keep going suspect
Date	2011-05-12 03:48 -0700
Organization	http://groups.google.com
Message-ID	<8a77e131-5db8-4e19-9d0d-28bb9af078f3@q14g2000prh.googlegroups.com> (permalink)
References	<ea2bc881-0397-4046-ac96-8a2bbb32063a@r20g2000yqd.googlegroups.com> <Xns9EE12A299A4Yazorman@127.0.0.1> <ae395e72-c4f8-4b85-b3a0-31e5b90ad173@e21g2000vbz.googlegroups.com>

Show all headers | View raw

On 11 Mai, 19:16, Admin Matt <admin.matt...@gmail.com> wrote:
> 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

Well, that is a good idea anyway - might improve performance as well.

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

You could install ProcessMonitor on the system with appropriate
filtering for LDF and MDF in "Path" field and probably file operations
(open, close).  That should give you an idea who is accessing those
files.

Kind regards

robert

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