Chat now with support
Chat with Support

NetVault Plug-in for SQL Server 11.0 - User Guide

Introducing Dell™ 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 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
Restoring data Troubleshooting

Restoring system databases for Online VDI restore with Plug-in for SQL Server

You can only restore system databases from backups that are created on the version of SQL Server® that the instance is running. For example, to restore a system database on an instance that is running on SQL Server 2005 SP1, use a backup that was created after the instance was upgraded to SQL Server 2005 SP1.
The master database must be accessible and at least partly usable for starting a SQL Server® Instance. If the master database becomes unusable, you can return the database to a usable state by either restoring the master from a current database backup or rebuilding the master.
You can restore the master database from a Full Database backup only if you are able to start the server instance. If severe damage to the master database prevents you from starting the SQL Server, rebuilding the master is the only option left. For more information, see Rebuilding the master Database in the SQL Server Books Online.
The restoration of the master database includes:
Restore a Full Database backup of the master database.
Because the changes made to master since the last backup were lost, re‑create them by performing those steps again.
After the master has been restored and changes reapplied, back up the master immediately.
Restoring the model or msdb database from a backup is required under the following circumstances:
The master database has been rebuilt. In this case, restore model from a backup because rebuilding master re-creates model.
The model or msdb database has been damaged, for example, due to media failure.
Restoring model or msdb is the same as performing a Complete Database restore of a user database.
Before restoring msdb, the SQL Server Agent Service in the Control Panel must be stopped. Dell also recommends that you shut down applications, because the restore procedure disconnects users when necessary.

Restoring databases involved in replication for Online VDI restore

Replication supports restoring replicated databases to the same SQL Server® Instance and database from which the backup was created. If you restore a replicated database from a backup to a different instance, replication settings cannot be preserved. In this case, re-create all publications and subscriptions after backups are restored.
For more information, see Strategies for Backing Up and Restoring Snapshot and Transactional Replication and Strategies for Backing Up and Restoring Merge Replication sections in the SQL Server Books Online.

Restoring data from Online VDI backups

Selecting Online VDI data for restore

On the Create Restore Job — Choose Saveset page, select Plug‑in for SQL Server from the Plugin Type list.
When you select a saveset, the following details are displayed in the Saveset Information area: Job ID, Job Title, server name, client name, plug-in name, saveset date and time, retirement setting, Incremental Backup or not, Archive or not, saveset size, and snapshot-based backup or not.
Click Next.
On the Create Selection Set page, select the data that you want to restore.
The database name is displayed when you open this node. For the Full File and Filegroup, Differential File and Filegroup, Partial Database, and Differential Partial Database backup types, you can open the database node and select the individual files or filegroups. For other backup types, further drill-down shows items but you cannot select them.
RESTORE DATABASE <DatabaseName> <ReadWriteFilegroupOptions>
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating