Chatta subito con l'assistenza
Chat con il supporto

NetVault Plug-in for SQL Server 12.2 - User Guide

Introducing NetVault Backup Plug-in for SQL Server Planning your SQL Server deployment Installing and removing the plug-in Configuring the plug-in Backing up data
Defining a backup strategy Understanding snapshot-based backups Reviewing the compression features Performing Online VDI backups Performing VSS backups in SQL Server Example of creating a full VDI backup of an AlwaysOn Availability Group on Windows
Restoring data Using the CLI with the plug-in Troubleshooting

Defining an Online VDI backup strategy and reviewing types

After selecting the recovery model that meets your requirements for each database, you can design and implement a corresponding backup strategy. When defining a SQL Server Online VDI Backup strategy, answer the following questions:

•
Is there a predictable off-peak period for full backups?
•
What is the frequency of updates and changes?
•
Are changes confined to a small or large number of tables in a database?

Answering these questions helps you define the type and frequency of backups that should be implemented.

The plug-in provides the following types of Online VDI Backup:

•
Full Database backup for Online VDI
•
Differential Database backup for Online VDI
•
Copy-Only backup for Online VDI
•
Incremental Transaction Log backup for Online VDI
•
Tail-Log backup for Online VDI
•
Full File and Filegroup backup for Online VDI
•
Differential File and Filegroup backup for Online VDI
•
Partial Database backup for Online VDI
•
Differential Partial Database Backup for Online VDI

Full Database backup for Online VDI

Full Database backups are supported by:

•
SQL Server versions: Windows - 2008 and later; Linux - 2017 and later
•
Recovery models: All

A Full Database backup is a backup of the entire database. It also includes part of the transaction log, which enables recovery of the database to the point at which the backup was completed.

Full Database backups consume more space and time per backup and are typically supplemented by differential backups, which are created more frequently. With Full Database backups, you can re-create an entire database in one step by restoring the database.

Differential Database backup for Online VDI

Differential Database backups are supported by:

•
SQL Server versions: Windows - 2008 and later; Linux - 2017 and later
•
Recovery models: All

With a Differential Database, back up only the data that has changed since the last Full Database backup is backed up. Differential backups are smaller and faster to create than the full backups.

A Differential Database backup is useful if some of the database’s tables are modified more frequently than others. In this case, Differential Database backups allow you to back up frequently without the overhead of Full Database backups.

Copy-Only backup for Online VDI

Copy-Only backups are supported by:

•
SQL Server versions: Windows - 2008 and later; Linux - 2017 and later
•
Recovery models: All

Copy-Only backups are independent of the normal sequence of backups. A Copy-Only backup cannot serve as the base backup for a series of differential backups as a Full Backup can. Performing a Copy-Only backup does not affect what is backed up by the next differential backup. Copy-Only backups are ideal for situations that require special purposes, such as creating test environments or standby databases.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione