I use SQL Server and have a huge database with large compressed backup size (about 250 GB). The backup scenario of this database is:
Create full backup at the first day of each month. Create Differential backup daily exclusive first day of each month.
also I use mirror backup in order to copy my backup file to another server.
Total time that need to create full backup is about 3 hour.
I look for a better scenario to create small backup size and copy faster than now.
In this database I have 2 filegroups (ArchiveFG and PRIMARY). The size of ArchiveFG is 200 GB, also this file group is read-only filegroup.
I don't know that can I use following scenario?
create full backup from ArchiveFG filegroup (One time). create full backup from PRIMARY filegroup the first day of each month. create differential backup from PRIMARY filegroup daily exclusive first day of each month.
And how can I restore backup with above scenario.
Thanks in advance