Posted by Robert Klemme on 07/04/06 06:57

nai wrote:
> 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.

Do you regularly do backups and shrink the TX log? If not, that's the
first thing I'd do.

Kind regards

robert

[Back to original message]