8 ways to back up SQL Server.

Method 1, full backup

Method 2, differential backup

Method 3, partial backup (read_write part of backup database)

Method 4, File backup

Method 5, Filegroup backup

Method 6, read-only backup

Method 7, log backup

--------------------------------------------------------------------------------------------------------------- --------------------------------------------

Method 1, full backup

Backup Database Studio
to disk = ' E:\Studio.bak ';
Go

On this basis, you can also compress the size of the. bak file

Backup Database Studio
to disk = ' E:\Studio_compressionVersion.bak '
with compression;
Go

You can see that the data is compressed. This reduces the IO but increases the CPU's job.

You can also stripe backup

Backup Database Studio
to disk = ' F:\Studio0.bak ',
Disk = ' G:\Studio2.bak ',
Disk = ' K:\Studio3.bak '
Go

You can see that the stripe can divide a. bak file into three, the point is here, because these three can be stored on a different hard disk. To achieve the purpose of shunt IO. This allows for quick

Complete the backup. SQL Server can offload up to 64 hard disks.

Mirrored backup

Backup Database Studio
to disk = ' E:\Studio.bak '
Mirror to disk = ' E:\Studio_mirror_1.bak '
Mirror to disk = ' E:\Studio_mirror_2.bak '
with format;
Go

You can see that the mirrored backup has multiple copies of the backup file, so that if one of them is not available, there is something else to use.

Method 2, differential backup

Backup Database Studio
to disk = ' E:\Studio.diff '
with differential;
Go

The data that the differential backup focuses on is only the changes in the database since the full backup of the database has been submitted.

Method 3, partial backup

Backup Database Studio
Read_write_filegroups
to disk = ' E:\Studio.par '
Go

Partial backups are only readable and writable portions of the database.

8 ways to back up SQL Server.