mastlog.ldf and other locked files

Whenever I back up my laptop, I get a series of messages that the files
in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
folder such as mastlog.ldf are being used by another application. The
backup stalls until I manually tell it to skip these files.
Is there any way to identify what application is using these files?
I am running WIndows XP.
Thanks,
Dani
<reachdani@.gmail.com> wrote in message
news:1131309673.446106.52540@.g44g2000cwa.googlegro ups.com...
> Whenever I back up my laptop, I get a series of messages that the files
> in the C:\Program Files\Microsoft SQL Server\MSSQL$MICROSOFTBCM\Data
> folder such as mastlog.ldf are being used by another application. The
> backup stalls until I manually tell it to skip these files.
> Is there any way to identify what application is using these files?
> I am running WIndows XP.
> Thanks,
> Dani
>
Mastlog.ldf is the log file for master. SQL Server will open the Master
database whether or not other applications are in use.
If you want to backup SQL databases then the best way is usually to use the
SQL BACKUP command. That's doubly so for Master. If you want to back them up
via the file system then shutdown the SQL Server service first - I assume
that won't be a problem on your laptop.
David Portas
SQL Server MVP
|||Hi
Looks like BCM = Business Contact Manager, a option for Microsoft Office
2003.
It seems to use MSDE to store data. MSDE is the free version of SQL Server.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:kLSdnSlrKtLb4fPeRVnyuQ@.giganews.com...
> <reachdani@.gmail.com> wrote in message
> news:1131309673.446106.52540@.g44g2000cwa.googlegro ups.com...
> Mastlog.ldf is the log file for master. SQL Server will open the Master
> database whether or not other applications are in use.
> If you want to backup SQL databases then the best way is usually to use
> the SQL BACKUP command. That's doubly so for Master. If you want to back
> them up via the file system then shutdown the SQL Server service first - I
> assume that won't be a problem on your laptop.
> --
> David Portas
> SQL Server MVP
> --
>