O'Reilly logo

Microsoft SharePoint 2010 Unleashed by Michael Noel, Colin Spence

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server Backup Methods

SQL Server offers a wide range of options to back up databases. These include the following:

Full— Complete database backup that includes transaction logs.

Differential— All data changes since the last full backup is backed up.

Transaction log backup— All transactions performed against the database since the last full backup or transaction log back up is backed up.

File and file group backup— A portion of the database is backed up.

Partial backup— All data in the primary group, every read-write file group, and any specified files are backed up. File groups marked read-only are skipped.

Differential partial backup— Although similar to partial backup, this backup records only changes to the data in the file ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required