question about logs

There are entries in the log that look like this:
Opening file D:\msssql\valdo.mdf
Opening file D:\msssql\valdo.mdf
Closing file D:\msssql\valdo.mdf
Closing file D:\msssql\valdo.mdf
This happens for each database and each entry is about 3 hundreths of a
second apart. Is this some kind of backup maybe? We use Veritas software and
I'm wondering if this is what their file level backup looks like.
Thanks,
--
Dan D.Are your databases set to auto-close?
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:4B8129B0-1C98-4980-8A9E-7D4938F80BC0@.microsoft.com...
> There are entries in the log that look like this:
> Opening file D:\msssql\valdo.mdf
> Opening file D:\msssql\valdo.mdf
> Closing file D:\msssql\valdo.mdf
> Closing file D:\msssql\valdo.mdf
> This happens for each database and each entry is about 3 hundreths of a
> second apart. Is this some kind of backup maybe? We use Veritas software
and
> I'm wondering if this is what their file level backup looks like.
> Thanks,
> --
> Dan D.|||Dan
Uncheck Auto Close feature of the database
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:4B8129B0-1C98-4980-8A9E-7D4938F80BC0@.microsoft.com...
> There are entries in the log that look like this:
> Opening file D:\msssql\valdo.mdf
> Opening file D:\msssql\valdo.mdf
> Closing file D:\msssql\valdo.mdf
> Closing file D:\msssql\valdo.mdf
> This happens for each database and each entry is about 3 hundreths of a
> second apart. Is this some kind of backup maybe? We use Veritas software
and
> I'm wondering if this is what their file level backup looks like.
> Thanks,
> --
> Dan D.|||Yes they are set to auto-close. However, I think something else is going on.
There are 6 databases on this server besides msdb, master, etc. During a 45
second period each database is closed and opened about 15 times - all 6 of
them. And then it doesn't happen again for 8 hours and then all of them are
closed and opened twice each.
It didn't happen for a couple of days and then again they were all closed
and then opened many times within a one minute period.
"Geoff N. Hiten" wrote:
> Are your databases set to auto-close?
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:4B8129B0-1C98-4980-8A9E-7D4938F80BC0@.microsoft.com...
> > There are entries in the log that look like this:
> >
> > Opening file D:\msssql\valdo.mdf
> > Opening file D:\msssql\valdo.mdf
> > Closing file D:\msssql\valdo.mdf
> > Closing file D:\msssql\valdo.mdf
> >
> > This happens for each database and each entry is about 3 hundreths of a
> > second apart. Is this some kind of backup maybe? We use Veritas software
> and
> > I'm wondering if this is what their file level backup looks like.
> >
> > Thanks,
> > --
> > Dan D.
>
>|||Maintenance plans? External apps touching the databases?
I would disable auto-close. I am not a big fan of that feature.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:F6FE635E-86A0-489D-9C63-928AF3C4CF78@.microsoft.com...
> Yes they are set to auto-close. However, I think something else is going
on.
> There are 6 databases on this server besides msdb, master, etc. During a
45
> second period each database is closed and opened about 15 times - all 6 of
> them. And then it doesn't happen again for 8 hours and then all of them
are
> closed and opened twice each.
> It didn't happen for a couple of days and then again they were all closed
> and then opened many times within a one minute period.
> "Geoff N. Hiten" wrote:
> > Are your databases set to auto-close?
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > news:4B8129B0-1C98-4980-8A9E-7D4938F80BC0@.microsoft.com...
> > > There are entries in the log that look like this:
> > >
> > > Opening file D:\msssql\valdo.mdf
> > > Opening file D:\msssql\valdo.mdf
> > > Closing file D:\msssql\valdo.mdf
> > > Closing file D:\msssql\valdo.mdf
> > >
> > > This happens for each database and each entry is about 3 hundreths of
a
> > > second apart. Is this some kind of backup maybe? We use Veritas
software
> > and
> > > I'm wondering if this is what their file level backup looks like.
> > >
> > > Thanks,
> > > --
> > > Dan D.
> >
> >
> >|||It's a development database that isn't used very much. There aren't any
maintenance plans set up.
I think I'll take your advice and disable that feature.
Thanks,
Dan D.
"Geoff N. Hiten" wrote:
> Maintenance plans? External apps touching the databases?
> I would disable auto-close. I am not a big fan of that feature.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:F6FE635E-86A0-489D-9C63-928AF3C4CF78@.microsoft.com...
> > Yes they are set to auto-close. However, I think something else is going
> on.
> > There are 6 databases on this server besides msdb, master, etc. During a
> 45
> > second period each database is closed and opened about 15 times - all 6 of
> > them. And then it doesn't happen again for 8 hours and then all of them
> are
> > closed and opened twice each.
> >
> > It didn't happen for a couple of days and then again they were all closed
> > and then opened many times within a one minute period.
> >
> > "Geoff N. Hiten" wrote:
> >
> > > Are your databases set to auto-close?
> > >
> > > --
> > > Geoff N. Hiten
> > > Microsoft SQL Server MVP
> > > Senior Database Administrator
> > > Careerbuilder.com
> > >
> > > I support the Professional Association for SQL Server
> > > www.sqlpass.org
> > >
> > > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > > news:4B8129B0-1C98-4980-8A9E-7D4938F80BC0@.microsoft.com...
> > > > There are entries in the log that look like this:
> > > >
> > > > Opening file D:\msssql\valdo.mdf
> > > > Opening file D:\msssql\valdo.mdf
> > > > Closing file D:\msssql\valdo.mdf
> > > > Closing file D:\msssql\valdo.mdf
> > > >
> > > > This happens for each database and each entry is about 3 hundreths of
> a
> > > > second apart. Is this some kind of backup maybe? We use Veritas
> software
> > > and
> > > > I'm wondering if this is what their file level backup looks like.
> > > >
> > > > Thanks,
> > > > --
> > > > Dan D.
> > >
> > >
> > >
>
>|||"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:B6FB1325-6A68-4302-AC27-24B63648BED3@.microsoft.com...
> It's a development database that isn't used very much. There aren't any
> maintenance plans set up.
> I think I'll take your advice and disable that feature.
>
I think when you run Enterprise Manager it has to open all databases to get
info and then they are autoclosed.
I think Kalen Delany had an article about this 3-4 months back in SQL Server
magazine.
> Thanks,
> Dan D.
> "Geoff N. Hiten" wrote:
> > Maintenance plans? External apps touching the databases?
> >
> > I would disable auto-close. I am not a big fan of that feature.
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > news:F6FE635E-86A0-489D-9C63-928AF3C4CF78@.microsoft.com...
> > > Yes they are set to auto-close. However, I think something else is
going
> > on.
> > > There are 6 databases on this server besides msdb, master, etc. During
a
> > 45
> > > second period each database is closed and opened about 15 times - all
6 of
> > > them. And then it doesn't happen again for 8 hours and then all of
them
> > are
> > > closed and opened twice each.
> > >
> > > It didn't happen for a couple of days and then again they were all
closed
> > > and then opened many times within a one minute period.
> > >
> > > "Geoff N. Hiten" wrote:
> > >
> > > > Are your databases set to auto-close?
> > > >
> > > > --
> > > > Geoff N. Hiten
> > > > Microsoft SQL Server MVP
> > > > Senior Database Administrator
> > > > Careerbuilder.com
> > > >
> > > > I support the Professional Association for SQL Server
> > > > www.sqlpass.org
> > > >
> > > > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > > > news:4B8129B0-1C98-4980-8A9E-7D4938F80BC0@.microsoft.com...
> > > > > There are entries in the log that look like this:
> > > > >
> > > > > Opening file D:\msssql\valdo.mdf
> > > > > Opening file D:\msssql\valdo.mdf
> > > > > Closing file D:\msssql\valdo.mdf
> > > > > Closing file D:\msssql\valdo.mdf
> > > > >
> > > > > This happens for each database and each entry is about 3 hundreths
of
> > a
> > > > > second apart. Is this some kind of backup maybe? We use Veritas
> > software
> > > > and
> > > > > I'm wondering if this is what their file level backup looks like.
> > > > >
> > > > > Thanks,
> > > > > --
> > > > > Dan D.
> > > >
> > > >
> > > >
> >
> >
> >|||I just tried that and you're right. EM opens and then closes the file.
Thanks
"Greg D. Moore (Strider)" wrote:
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:B6FB1325-6A68-4302-AC27-24B63648BED3@.microsoft.com...
> > It's a development database that isn't used very much. There aren't any
> > maintenance plans set up.
> >
> > I think I'll take your advice and disable that feature.
> >
> I think when you run Enterprise Manager it has to open all databases to get
> info and then they are autoclosed.
> I think Kalen Delany had an article about this 3-4 months back in SQL Server
> magazine.
>
> > Thanks,
> >
> > Dan D.
> >
> > "Geoff N. Hiten" wrote:
> >
> > > Maintenance plans? External apps touching the databases?
> > >
> > > I would disable auto-close. I am not a big fan of that feature.
> > >
> > > --
> > > Geoff N. Hiten
> > > Microsoft SQL Server MVP
> > > Senior Database Administrator
> > > Careerbuilder.com
> > >
> > > I support the Professional Association for SQL Server
> > > www.sqlpass.org
> > >
> > > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > > news:F6FE635E-86A0-489D-9C63-928AF3C4CF78@.microsoft.com...
> > > > Yes they are set to auto-close. However, I think something else is
> going
> > > on.
> > > > There are 6 databases on this server besides msdb, master, etc. During
> a
> > > 45
> > > > second period each database is closed and opened about 15 times - all
> 6 of
> > > > them. And then it doesn't happen again for 8 hours and then all of
> them
> > > are
> > > > closed and opened twice each.
> > > >
> > > > It didn't happen for a couple of days and then again they were all
> closed
> > > > and then opened many times within a one minute period.
> > > >
> > > > "Geoff N. Hiten" wrote:
> > > >
> > > > > Are your databases set to auto-close?
> > > > >
> > > > > --
> > > > > Geoff N. Hiten
> > > > > Microsoft SQL Server MVP
> > > > > Senior Database Administrator
> > > > > Careerbuilder.com
> > > > >
> > > > > I support the Professional Association for SQL Server
> > > > > www.sqlpass.org
> > > > >
> > > > > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > > > > news:4B8129B0-1C98-4980-8A9E-7D4938F80BC0@.microsoft.com...
> > > > > > There are entries in the log that look like this:
> > > > > >
> > > > > > Opening file D:\msssql\valdo.mdf
> > > > > > Opening file D:\msssql\valdo.mdf
> > > > > > Closing file D:\msssql\valdo.mdf
> > > > > > Closing file D:\msssql\valdo.mdf
> > > > > >
> > > > > > This happens for each database and each entry is about 3 hundreths
> of
> > > a
> > > > > > second apart. Is this some kind of backup maybe? We use Veritas
> > > software
> > > > > and
> > > > > > I'm wondering if this is what their file level backup looks like.
> > > > > >
> > > > > > Thanks,
> > > > > > --
> > > > > > Dan D.
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>

Question about Antivirus install to db server.

Hi,
SA want install the Antivirus software on production database server, he
said he will exclude those files extension with mdf, ldf, and ndf from the
VirusScan engine to avoid performance issues. My question is how about the
bak extension files? Do I also need exclude backup files?
Regards!
ChenNo
You need backup file only when you are restoring database. SQL Server
does not use it for any other operations. It may be possible your other
non sql files also contains .bak extension. So its better to check it.
Regards
Amish Shah

Question about Antivirus install to db server.

Hi,
SA want install the Antivirus software on production database server, he
said he will exclude those files extension with mdf, ldf, and ndf from the
VirusScan engine to avoid performance issues. My question is how about the
bak extension files? Do I also need exclude backup files?
Regards!
ChenNo
You need backup file only when you are restoring database. SQL Server
does not use it for any other operations. It may be possible your other
non sql files also contains .bak extension. So its better to check it.
Regards
Amish Shah