question about master system database

Hi, i use sql server 2005 express where i created several databases. When opening Management Studio, i can see, besides my databases, also Master, Model etc .. which manage the databases. Now i also use MDF files which are disseminated on the same server. I see that for one given user, there is also a Master, Model etc ... in c:\document and settings\that user\ ....

My question is: are those local Master, Model etc ... related with the central Master, Model ... of the central database system or are they independant? What if i delete the MDF files and its related system files in c:\.doc and settings\.. ?

Thanks

When you check under properties for the database in the Management Studio you should see the database is pointing to a particular file on the drives. So other than this MDF file you could delete any other MDF files with same name if you are sure no one else is using the files. You could try moving the files to a different location and if it lets you do it then no one is using it. If the files are being used you would get an '..Access violation..' or ' file in use..' error.

|||thanks

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