GilaMonster (11/18/2012)
Don't append backups to one file. Backups should ideally each to their own file, preferably time-stamped (DatabaseName20121115211501.trn)To restore to a point in time, you need a full backup taken before that point and all log backups since then (not just one of them)
1-Do you mean to overwrite?
2-I am thinking of having t he full backup of the database every mid-night and transaction log backups every 15 minutes.
Does this mean if there is a disaster at 11:55 pm, to restore to 11:45 pm I should a) get the previous midnight database backup, b) from that point I have to restore every singly transaction log in order until 11:45 pm?