I got a task for backing up my clients data through internet. Client has about 50 GB of data there. So I need to back up the data and pass through internet, but it takes about 8 to 9 hours for this process because our internet connection is slow. So I can't resolve client issues in time.
So I decide to change my back up strategy. I tried differential backup. It solves somewhat my problem but not. Because it takes back up from previous full back up. So I tried to implement incremental backup. I know this will solve my problem. But SQL Server doesn't support incremental backup.
So please help me if there any way to resolve my issue. Also tell me why there is no incremental backup in SQL Server. But DB2 has.
I am using SQL Server 2008 R2.