Would that not be the same thing as truncating the file then deleting it
?

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed]
Sent: Thursday, May 22, 2003 9:13 AM
To: LazyDBA.com Discussion
Subject: RE: Consolidating log files ...

Guest What! This is not correct.

You can move the information from the log file and migrate them to the
primary log file.


I have done that many times and it work properly.

Here is how you go about doing that.

-- Use the following to move the data from one device to a primary
-- device.

DBCC SHRINKFILE (LOGFILENAME2, emptyfile)
GO

DBCC SHRINKFILE (LOGFILENAME1, emptyfile)
go


Change the LOGFILENAME 1 and 2 to the log file you are refering to.

NOTE: For the process to work properly you have to select the last log
file
first, and work your way up to the last log file you want to move data
from.

i.e you have the primary log file and you have log 1 and log 2.

Run the command on log 2, once done delete the log file
Run the command on log 1, and delete the log file.

Once completed you should be having only one log file.

If everything as work properly you will be able to delete the log files.
If
you are still having information in the log files you will not be
allowed to
delete the log files.


-----Original Message-----
From: Kannan M [mailto:[Email Address Removed]
Sent: Thursday, May 22, 2003 7:13 AM
To: LazyDBA.com Discussion
Subject: Re: Consolidating log files ...


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] 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] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page