Backing up and restoring SQL Server data

To protect content on a SQL Server server, first register the SQL Server instance so that IBM Spectrum Protect Plus recognizes it. Then create jobs for backup and restore operations.

System requirements

Ensure that your SQL Server environment meets the system requirements in Microsoft SQL Server requirements.

Registration and authentication

The default security policy uses the Windows NTLM protocol, and the user identity format follows the default domain\name format.

When you are using Windows group policy objects (GPO), the group policy object setting, Network security: LAN Manager authentication level must be set correctly. Set it with one of the following options:
  • Not Defined
  • Send NTLMv2 response only
  • Send NTLMv2 response only. Refuse LM
  • Send NTLMv2 response only. Refuse LM & NTLM