Here is what I am doing,
- Take full FILE backup at 1.00 AM
- Take differential FILE backup every 15 minutes
- And we ftp all data to other location and restore everything there
So now from My Source database to Destination database, every 15 minutes, its replicated remotely on other node. Now we do have full files, do we still need to backup transaction logs? We are willing to sacrifice last 15 minutes of data in case of disaster, because thats the best we can manage remotely.
Because even if anything crashes, last 15 minutes of data will never be recovered in case of hardware failure event, and to bring everything up will take more then a day, where else other server can start taking over and go on.
So ideally, Imagin a situation as below,
1.00 AM full file backup transferred to server B 1.15 AM differential file backup transferred to server B 1.30 ... same as above 1.45 ... same as above 1.50 ... crash, machine down...
at this position, can Server B continue from 1.45 restored database?
Because if machine crashes at 1.50, it will not be able to transfer Log backups anyway, and we have Full backup and differential backups restored on server B already.
So question redefined, if we have correct Full + Differential File backups, do we still need log backups?
As long as till 1.45 data is consistent we are good to go.