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

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

Re: Databases keep going suspect

Show all headers | 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