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

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

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

Master-Detail Searching, best approach?

Hello, I'm relatively new to using full-text search. I'm working on a =
document management program.
Basically my data it stored in two tables, [Documents], and =
[DocDetails], with a one-to-many relationship. [Documents] contains a =
record for each document stored, and [DocDetails] has many records =
concerning a document, each with an associated text field.
I'm really after the ability to search on a query '"jane" and "doe"', =
where I would be able to pull from [Documents] all documents that have =
matching records in [DocDetails]. My problem comes in how to query =
[DocDetails], some records would have "jane" in them, and some records =
would have "doe" in them, never would you see one record in [DocDetails] =
having both terms in the same text field. (I think this kinda negates =
using a strategy where the query has an "and" or "or" in it.
Maybe there is a way around this, I just haven't thought of. Right now, =
the only thing I can this is to split up my queries into only one word, =
and join the results.
If someone could give me a nudge in the right direction I'd appreciate =
it!
Thanks!,
--Michael
Raterus,
The below code was posted recently in regards to a "Parent - Child"
relationship, and should also work with your "Master - Detail" searching.
Tables:
contact(contact_id, name)
role(role_id, description)
contact_role (contact_id, role_id)
How can I find all contact where the search string is in the contact name
and or roles description? This is the quick and simplest way. You can
rewrite this query using outer-joins. The code is not tested. So expect some
syntax errors.
select * from contact where contactid in
(select contactid from contact_role where contactid in (select key from
containstable(contact,name,'search string') or
roleid in (select key from containstable(role,description,'search
string'))
You should be able to alter the above code to fit your tables. If you have
an alternative approach or additional questions, please post them here..
Regards,
John
"Raterus" <raterus@.spam.org> wrote in message
news:OI#yuv1NEHA.556@.TK2MSFTNGP10.phx.gbl...
Hello, I'm relatively new to using full-text search. I'm working on a
document management program.
Basically my data it stored in two tables, [Documents], and [DocDetails],
with a one-to-many relationship. [Documents] contains a record for each
document stored, and [DocDetails] has many records concerning a document,
each with an associated text field.
I'm really after the ability to search on a query '"jane" and "doe"', where
I would be able to pull from [Documents] all documents that have matching
records in [DocDetails]. My problem comes in how to query [DocDetails],
some records would have "jane" in them, and some records would have "doe" in
them, never would you see one record in [DocDetails] having both terms in
the same text field. (I think this kinda negates using a strategy where the
query has an "and" or "or" in it.
Maybe there is a way around this, I just haven't thought of. Right now, the
only thing I can this is to split up my queries into only one word, and join
the results.
If someone could give me a nudge in the right direction I'd appreciate it!
Thanks!,
--Michael
|||Actually that was the first post I read before I posted, it helped =
initally. I've adapted it a little bit and have come up with this. =
It's a mess, I know it :-) It is working how I want it to though, the =
only problem I forsee, is how do I have different queries for a =
different number of search terms. Using this strategy I'll have to have =
a different query if they search for "jane doe john brown" rather than =
just "jane doe" This is all for an asp.net web application, so it =
wouldn't be that difficult for me to create my own query on the fly and =
send it over, but if there is a better way, I'd love to hear it!
select * from documents where docID in
(
select t1.docID
from (
select docID
from docdetails
where ddID in
(
select [key]
from containstable(docdetails,value,'"jane"')
)
) as t1 inner join=20
(
select docID
from docdetails
where ddID in
(
select [key]
from containstable(docdetails,value,'"doe"')
)
) as t2 on t1.docID =3D t2.docID
)
"John Kane" <jt-kane@.comcast.net> wrote in message =
news:%235axQM2NEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Raterus,
> The below code was posted recently in regards to a "Parent - Child"
> relationship, and should also work with your "Master - Detail" =
searching.
>=20
> Tables:
> contact(contact_id, name)
> role(role_id, description)
> contact_role (contact_id, role_id)
>=20
> How can I find all contact where the search string is in the contact =
name
> and or roles description? This is the quick and simplest way. You can
> rewrite this query using outer-joins. The code is not tested. So =
expect some
> syntax errors.
>=20
> select * from contact where contactid in
> (select contactid from contact_role where contactid in (select key =
from
> containstable(contact,name,'search string') or
> roleid in (select key from containstable(role,description,'search
> string'))
>=20
> You should be able to alter the above code to fit your tables. If you =
have
> an alternative approach or additional questions, please post them =
here..
>=20
> Regards,
> John
>=20
>=20
>=20
>=20
> "Raterus" <raterus@.spam.org> wrote in message
> news:OI#yuv1NEHA.556@.TK2MSFTNGP10.phx.gbl...
> Hello, I'm relatively new to using full-text search. I'm working on a
> document management program.
>=20
> Basically my data it stored in two tables, [Documents], and =
[DocDetails],
> with a one-to-many relationship. [Documents] contains a record for =
each
> document stored, and [DocDetails] has many records concerning a =
document,
> each with an associated text field.
>=20
> I'm really after the ability to search on a query '"jane" and "doe"', =
where
> I would be able to pull from [Documents] all documents that have =
matching
> records in [DocDetails]. My problem comes in how to query =
[DocDetails],
> some records would have "jane" in them, and some records would have =
"doe" in
> them, never would you see one record in [DocDetails] having both terms =
in
> the same text field. (I think this kinda negates using a strategy =
where the
> query has an "and" or "or" in it.
>=20
> Maybe there is a way around this, I just haven't thought of. Right =
now, the
> only thing I can this is to split up my queries into only one word, =
and join
> the results.
>=20
> If someone could give me a nudge in the right direction I'd appreciate =
it!
>=20
> Thanks!,
> --Michael
>=20
>