![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 -- |
![]() |
| Thread Tools | |
| Display Modes | |
| |