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" ?
Your backup script would use the timestamp to form part of the filename. It's common to append the database name, backup type and timestamp to form the backup filename.
E.g. a log backup run on Noddy database at 15:34pm would generate a file called
Noddy_TLog_20121119_153400.trn
arkiboys (11/19/2012)
2- restoring each transaction log sinice the previous midnight seems to be a long process. How about introducing a differential backup?
Now your learning, good idea 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉