What is an SQL Server backup?
Why should you create an SQL Server backup?
How do you create a SQL Server backup?
sql server
Partial Backups
Partial backups are a type of backup which was first introduced with SQL Server 2005.
These types of backups were designed for use with the simple recovery model in order to improve flexibility in terms of backing up very very large databases that can contain at least one read-only filegroup.