Heyo,
This question is quite simple. I have a T-SQL backup script run by SQL Server Agent.
A differential backup is taken every hour, bar once per day, when a full is taken. After either differential or full, a transaction log is backed up. In addition, every 10 minutes, the transaction log solely is backed up again.
I save the transaction log with the date including the hour in the file name; in other words, output to the same filename 6 times an hour, then a new transaction log file is made.
Should I be saving to the same file 6 times per hour? Is SQL by default appending to the log or is it overwriting? Will restore operations be more complicated with multiple backups in one file?
For completeness, here is the log backup statement:
BACKUP LOG @db
TO DISK = '\\somedrive\path\sqlservername\yymmdd-hh.trn'
WITH NAME='Log network backup.', DESCRIPTION='long backup description with time, DB and server name'
The server versions are SQL 2008 R2 and SQL 2012.