When a databases has the transaction log and data on the same device this procedures moves the transaction log to another device.

sp_logdevice dbname, devname

Parameter information :
»dbname : Name of a database
»devname : Name of device to move the transaction log to.