SQL Server backup
Posted
by
zzz777
on Server Fault
See other posts from Server Fault
or by zzz777
Published on 2011-03-11T11:56:15Z
Indexed on
2011/03/13
0:12 UTC
Read the original article
Hit count: 516
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.
© Server Fault or respective owner
