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.