Advanced backup scenarios

Now that we have all three basic backup types described, we have sufficient information to decide how to summarize our needs and choose the right backup strategy. It's also very important to ensure that backup is reliable and fast. We also have to maintain backups for larger databases composed of more files or filegroups. SQL Server provides you with a set of features covering all three needs.