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...
> and
>
>
|||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[vbcol=seagreen]
> 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:
a[vbcol=seagreen]
software[vbcol=seagreen]
|||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...
> on.
> 45
> are
> a
> software
>
>
|||"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.
[vbcol=seagreen]
> Thanks,
> Dan D.
> "Geoff N. Hiten" wrote:
going[vbcol=seagreen]
a[vbcol=seagreen]
6 of[vbcol=seagreen]
them[vbcol=seagreen]
closed[vbcol=seagreen]
of[vbcol=seagreen]
|||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...
> 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.
>
> going
> a
> 6 of
> them
> closed
> of
>
>