Posted by nai on 07/03/06 15:32

Hi all,

I have a database with 20GB transaction log file.
The recovery model of the database is Full.
I need to move the T. log file to a new location with the minimal
downtime.
I know I can do this by dettaching the DB, copying the T. Log and
attaching it at the new location. This will take some time though as
copying the T. log file will take up some time.

I thoght that I could maybe create a secondary T. log file and delete
the primary T. log file.
What does it take so I'm able to delete the primary T. log file? Can
you please explain how to accomplish this?

Also, if you can figure out of a better way, then please let me know.

• Next in forum: Re: Does anyone know of a tool that allows a SQL Server database to be
• Prev in forum: Re: Update statement, then insert what wasn't available to be updated.
• Thread view: How to move transaction logs on-line?

[Reply to this message]