arkiboys (11/19/2012)
1- if the backup of transaction log is scheduled to run say every 15 minutes then how can I "write to a new file each time with a unique name" ?
Have a look at Ola Hallengren's SQL Server Maintenance Solution. It's very easy to setup and use. Read and download from:
Many DBAs use it.