how to tell when log file is not in use

sql2k sp3
Ive got a db with almost 4 gig of free space. I created a
proc that attempted to shrink it last night before doing
my backup so as to not backup this space. But I got the
message "Cannot shrink log file 2 (bla_log) because all
logical log files are in use". So I either need a way to
tell my backup to ignore the free space(this would be
preferable, but I dont this its possible) or tell my
shrink proc to see if the Log file is not in use.
TIA, ChrisBackup does not put your free space into the backup file. So don't worry
about that.
hth
Quentin
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:09ff01c3dc46$b4e9d2b0$a601280a@.phx.gbl...

quote:

---

> sql2k sp3
> Ive got a db with almost 4 gig of free space. I created a
> proc that attempted to shrink it last night before doing
> my backup so as to not backup this space. But I got the
> message "Cannot shrink log file 2 (bla_log) because all
> logical log files are in use". So I either need a way to
> tell my backup to ignore the free space(this would be
> preferable, but I dont this its possible) or tell my
> shrink proc to see if the Log file is not in use.
> TIA, Chris

---

|||Then why do I have a backup thats 12.7 gigs when the used
space is about 9.7 gigs?

quote:

---

>--Original Message--
>Backup does not put your free space into the backup

---

file. So don't worry

quote:

---

>about that.
>hth
>Quentin
>"chris" <anonymous@.discussions.microsoft.com> wrote in

---

message

quote:

---

>news:09ff01c3dc46$b4e9d2b0$a601280a@.phx.gbl...
a[QUOTE]
>
>.
>

---

|||Have you updated the used space information?
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:018e01c3dc54$5ee62310$a101280a@.phx.gbl...[QUOTE]
> Then why do I have a backup thats 12.7 gigs when the used
> space is about 9.7 gigs?
>
> file. So don't worry
> message
> a|||Yes.
"Quentin Ran" <ab@.who.com> wrote in message
news:#9DozhG3DHA.2296@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Have you updated the used space information?
> "chris" <anonymous@.discussions.microsoft.com> wrote in message
> news:018e01c3dc54$5ee62310$a101280a@.phx.gbl...
>

---