SQL Server backup
- by zzz777
I have
Full-Backup-A
Transaction-Log-Backup-A
Transaction-Log-Backup-B
(*) - I have to restore this point
Full-Backup-B
How to do it? It seems that the only way is
Full-Backup-A
Transaction-Log-Backup-A
Transaction-Log-Backup-B
Shut-off client access
Transaction-Log-C
Full-Backup-B
Allow client access
Are there any other ways to guarantee that nothing did happen with the database between last transaction log and the next full backup. I was thinking about
a. Starting transaction log backup simultaneously with full backup.
b. Using differential back up while clients are connected and making full backup during maintenance window only
c. Run replication and back-up the replica, stopping and restoring duplication services in points 4 and 7
and feel that it is actually hopeless.