dbTalk Databases Forums  

mastlog.ldf and other locked files

microsoft.public.sqlserver.server microsoft.public.sqlserver.server


Discuss mastlog.ldf and other locked files in the microsoft.public.sqlserver.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
reachdani@gmail.com
 
Posts: n/a

Default mastlog.ldf and other locked files - 11-06-2005 , 02:41 PM






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


Reply With Quote
  #2  
Old   
David Portas
 
Posts: n/a

Default Re: mastlog.ldf and other locked files - 11-06-2005 , 03:57 PM






<reachdani (AT) gmail (DOT) com> wrote

Quote:
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
--




Reply With Quote
  #3  
Old   
Mike Epprecht \(SQL MVP\)
 
Posts: n/a

Default Re: mastlog.ldf and other locked files - 11-06-2005 , 04:06 PM



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 (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"David Portas" <REMOVE_BEFORE_REPLYING_dportas (AT) acm (DOT) org> wrote

Quote:
reachdani (AT) gmail (DOT) com> wrote in message
news:1131309673.446106.52540 (AT) g44g2000cwa (DOT) googlegroups.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
--





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.