Steps required after a SQL Server host-level restore
Perform these steps after you have restored a host-level SQL Server snapshot from the NetBackup UI. These steps are required irrespective of whether you are restoring the snapshot to the original location or to a new location.
Before you proceed, verify the following:
Ensure that the SQL Server user account on the Windows host where you intend to revert the shadow copy, has full access to the restore data.
Ensure that the
pagefile.sysis not present on the drive that is selected for the snapshot creation or snapshot restore.The snapshot creation and snapshot restore operations will fail if the file is present on the selected drives.
Perform the following steps to revert the shadow copy
- Connect to the Windows host where the SQL Server instance is running.
Ensure that you use an account that has administrator privileges on the host.
- Stop the SQL Server service on the Windows host.
- Open a command prompt window. If Windows UAC is enabled on the host, open the command prompt in the Run as administrator mode.
- Navigate to
%programdata%\Veritas\CloudPoint\tmp\tools\windows\tools\directory, and then run the following command from there:vss_snapshot.exe --revertSnapshot
The command displays a json output with Status = 0 that confirms that the operation is successful.
This command reverts the shadow copies for all the drives, except the system drive. The SQL Server service is stopped before the snapshot is reverted and automatically started after the revert operation is successful.
- Start the SQL Server service on the Windows host.