Hi,
"It is not possible to migrate the transaction log data from one log file to
another to delete a transaction log file. To purge inactive transactions
from a transaction log file, the transaction log must be truncated or backed
up. When the transaction log file no longer contains any active or inactive
transactions, the log file can be removed from the database." -- MS

After log backup/ truncation, use ALTER DATABASE command to remove the log
file by giving logical file name.

Hope this will help,

Kannan M






----- Original Message -----
From: "Noble Bajal" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, May 22, 2003 1:43 PM
Subject: Consolidating log files ...


> Hi,
>
> One of our database has 3 log files in different
> locations.
>
> Is there is any way to consolidate all those 3 log
> files into one file (in one location)?
>
> Advanced thanks for helping minds.
>
> --- Adil Basha <[Email Address Removed] wrote:
> > Hi All,
> > Greetings,
> > Please help in this 2 questions
> > Wht is the difference between MSsql 7 and 2000.
> > how to view log files content.
> >
> > Waiting for reply
> > TIA
> > Regards
> > Adil
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > The New Yahoo! Search - Faster. Easier. Bingo.
> > http://search.yahoo.com
> >
> >
> ---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> > JUST REPLY
> > To unsubscribe, e-mail:
> > mssqldba-[Email Address Removed] > For additional commands, e-mail:
> > mssqldba-[Email Address Removed] >
>
>
> =====
>
> Best Regards,
> Bajal Mohamed.
>
> Mobile : + 673 + 8611056
>
> Time and tide wait for none
>
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> http://search.yahoo.com
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page