backup Transaction Log

Hi All,
Yesterday i posted my queston and i got couple of replies.
However, I was not clear with how i could back up a
transaction log file that is 25 GB when i have only 1GB
free space available.
Does it mean that i should not worry about the size of
the disk space available when i run the following code:
BACKUP LOG pubs WITH TRUNCATE_ONLY
Thank you,
MitraCorrect. Incidentally, you might want to read the documentation on the
commands before you do anything recommended in the newsgroups to make sure
you understand what the commands do. After all, we are not affected if your
database is destroyed.
"Mittra Fathollahi" <mitra928@.hotmail.com> wrote in message
news:138f701c44421$7e747f30$a601280a@.phx.gbl...
> Hi All,
> Yesterday i posted my queston and i got couple of replies.
> However, I was not clear with how i could back up a
> transaction log file that is 25 GB when i have only 1GB
> free space available.
> Does it mean that i should not worry about the size of
> the disk space available when i run the following code:
> BACKUP LOG pubs WITH TRUNCATE_ONLY
> Thank you,
> Mitra|||Hi,
Look into the SQL Server Recovery models documentation in Books online.
I recommend you to set the recovery model to "SIMPLE" incase if your
database is not a production data.
In this model the transaction file will be cleared on each commit. This will
ensure that your transaction file wont grow that big.
Thanks
Hari
MCDBA
"Scott Morris" <bogus@.bogus.com> wrote in message
news:OHrx7cCREHA.2572@.TK2MSFTNGP12.phx.gbl...
> Correct. Incidentally, you might want to read the documentation on the
> commands before you do anything recommended in the newsgroups to make sure
> you understand what the commands do. After all, we are not affected if
your
> database is destroyed.
> "Mittra Fathollahi" <mitra928@.hotmail.com> wrote in message
> news:138f701c44421$7e747f30$a601280a@.phx.gbl...
> > Hi All,
> >
> > Yesterday i posted my queston and i got couple of replies.
> >
> > However, I was not clear with how i could back up a
> > transaction log file that is 25 GB when i have only 1GB
> > free space available.
> >
> > Does it mean that i should not worry about the size of
> > the disk space available when i run the following code:
> > BACKUP LOG pubs WITH TRUNCATE_ONLY
> >
> > Thank you,
> >
> > Mitra
>