This is a follow-up to an earlier post (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24336568.html
My 5.5 Gb SQL Server 2000 database grows at about 10 Mb per day. I want to implement a better backup strategy that reduces the amount of data loss at risk in the event of a failure. I'm not completely sure of the need for transactional backups. Our daily complete backup currently creates a file about 75 Mb in size.
Am I correct that transactional backups just reduce the size of the current transaction log? If I didn't perform any transactional backups, can't I still restore the database from the last complete backup and the current transaction log? Or is the transaction log trashed if there is a failure? Are there other benefits to backing up the transaction log?
Given our small transaction activity, having frequent differential backups may be sufficient, if we can live with a small loss of data. Recommendations?