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