If you use Full Recovery model you can take transaction log backups. Usually DBAs schedule a FULL backup(lets say scheduled daily at 1am), a differential backup (lets say scheduled every...