I am trying to understand exactly how backups work for SQL Server.
The hosting provider have a scheduled FULL backup every night. There are also a number of DIFF backups taken during the day.
We are now planning a transfer to another hosting provider and want to take a new full backup which we want to start at say 1 PM and then later transfer the DIFF backups. (The current hosting provider is responsible for the other backups, so we don't want to mess with those.)
Can two DIFF backups be "connected" to two different FULL backups? How do I make sure that the DIFF backup I take is related to the correct (my) FULL backup? (Ok, I realize the question is a bit fuzzy, please help me with proper concepts).
The source db is SQL Server 2012 and destination db is 2014 (both web editions).