I am taking daily backups of a SQL Server database. Right now the
.bak file is about 2GB and it is growing day by day. There is a scheduled job is running which moves this
.bak file from one location to another.
Is there a way to save the
.bak file in chunks - like
so it will be much easier to move small data and merge at destination?