Chat now with support
지원 담당자와 채팅

NetVault Backup 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

Setting up SQL Server Authentication for SQL Server 2012 or later (Windows only)

Starting with SQL Server 2012, security privileges changed and you cannot use the LocalSystem account. Previously, you could use the LocalSystem account as the default for the sysadmin role. For SQL Server 2012 or later, use a domain account — including Administrator — that has the SQL Server sysadmin role or change the Log on as option for SQL Server Service to use a domain user that has the required privileges. If the SQL Server is not part of a domain, you can use a local user that has the sysadmin role or change the Log on as option for SQL Server Service to use a local user that has the required privileges.

In Windows Control Panel > Administrative > Services, locate and select NetVault Process Manager, and click Stop. Right-click NetVault Process Manager, and select Properties. On the Log On tab, ensure that NetVault Backup runs using the account that has the SQL Server sysadmin role. Start the NetVault Process Manager.
In the SQL Server Configuration Manager, click SQL Server Services. In the details pane, right-click the name of the applicable SQL Server Instance, and click Properties. In the SQL Server <instanceName> Properties dialog box, click the Log On tab. For Log on as, select the account that has the SQL Server sysadmin role. In Windows Control Panel > Administrative > Services, stop and start the SQL Server Service.
Use SQL Server Management Studio to add the domain or local user account that has the sysadmin privileges to the SQL Server. You can use SQL Server Management Studio to add this account, or enter the following in a command prompt:
CREATE LOGIN [<domainName>\<loginName>] FROM WINDOWS;
SP_ADDSRVROLEMEMBER '<domainName>\<loginName>', 'sysadmin'
NOTE: You can assign the SQL Server sysadmin role to the default Local System user (NT AUTHORITY\SYSTEM), which lets the Plug‑in for SQL Server log into the SQL Server Instances without prompting for credentials. Provisioning the Local System user (NT AUTHORITY\SYSTEM) with the sysadmin role might result in other applications being able to log into the SQL Server Instances without providing credentials. Before assigning the sysadmin role to the Local System user (NT AUTHORITY\SYSTEM), ensure that it is allowed under your compliance requirements.

Configuring domain administrator account for service exploration

For certain activities on Windows, it is necessary to impersonate a member of Administrators group on the client(s). An Enter Domain Administrator option is added in the context menu to configure a Windows Domain Administrator for clusters, even if the default login configuration is not a Windows user.

1
In the Navigation pane, click Create Backup Job, and click Create New next to the Selections list.
3
Click Plug‑in for SQL Server.
4
From the context menu, select Enter Domain Administrator.
User Name: Specify a domain Windows Administrator user name.
Password: Enter the password associated with the user specified in the preceding field.
Domain: Enter the name of the domain.
Reset to blank saved User Name, Password, and Domain: Select this option to reset to the blank or empty, the values stored in the plug-in for User Name, Password, and Domain.

 

Backing up data

Defining a backup strategy

The purpose of creating SQL Server backups is to recover a database that is damaged from media failure or data corruption. Reliable use of backup for recovery requires a strategy that maximizes data availability and minimizes data loss, while accounting for defined business requirements.

A backup strategy is divided into two pieces: a backup piece and a restore piece.

IMPORTANT: If you use Plug‑in for SQL Server, verify that you are not using a third-party program to complete additional backups of SQL Server. Otherwise, a conflict might occur during the restore or recovery process when the differential backups do not match.

For more information, review the following topics:

관련 문서