Posted by Cimode on 07/04/06 13:22

1)backup you log to a specific local location...
2) copy it on another machine (using xp_cmdshell)
3) call for a restore log by remotely calling a repote procedure on the
destination instance (you need to declare the remote instance as a
linked server first though)

Hope this helps...
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.

[Back to original message]