Skip to main content
SnapCenter Software 6.0

Back up SQL resources

Contributors netapp-nsriram netapp-soumikd netapp-asubhas
PDFs

If a resource is not yet part of any resource group, you can back up the resource from the Resources page.

About this task

  • For Windows credentials authentication, you must set up your credential before installing the plug-ins.

  • For SQL Server instance authentication, you must add the credential after installing the plug-ins.

  • For gMSA authentication, you must setup gMSA while registering the host with SnapCenter in the Add Host or Modify Host page to enable and use the gMSA.

  • If the host is added with gMSA and if the gMSA has login and system admin privileges, then gMSA is allowed to connect to the SQL instance.

    • SnapCenter will verify whether authentication for SQL instances is configured. If the authentication is configured, the SQL instance will be accessed using this credential.

    • If the authentication is not configured, use gMSA to see if the SQL plug-in is currently operating. If the plug-in is operating, it will be used to establish a connection to the SQL instance.

    • The SQL instance will be accessed via Windows credentials authentication when both authentication for SQL instances is not configured and the plug-in is not operational.

SnapCenter UI
Steps

  1. In the left navigation pane, select Resources, and then select the appropriate plug-in from the list.

  2. In the Resources page, select Database ,or Instance, or Availability Group from the View drop-down list.

    1. Select the database, or instance, or availability group that you want to back up.

      When you take a backup of an instance, the information about the last backup status or the timestamp of that instance will not be available in the resources page.

      In the topology view, you cannot differentiate whether the backup status, timestamp, or backup is for an instance or a database.

  3. In the Resources page, select the custom name format for Snapshot copy check box, and then enter a custom name format that you want to use for the Snapshot name.

    For example, customtext_policy_hostname or resource_hostname. By default, a timestamp is appended to the Snapshot name.

  4. In the Policies page, perform the following tasks:

    1. In the Policies section, select one or more policies from the drop-down list.

      You can create a policy by selecting add policy from resourcegroup to start the policy wizard.

      In the Configure schedules for selected policies section, the selected policies are listed.

    2. Select add policy from resourcegroup in the Configure Schedules column for the policy for which you want to configure a schedule.

    3. In the Add schedules for policy policy_name dialog box, configure the schedule, and then select OK.

      Here policy_name is the name of the policy that you have selected.

      The configured schedules are listed in the Applied Schedules column.

    4. Select the Use Microsoft SQL Server scheduler, and then select the scheduler instance from the Scheduler Instance drop-down list that is associated with the scheduling policy.

  5. In the Verification page, perform the following steps:

    1. Select the verification server from the Verification server drop-down list.

      You can select multiple verification servers (local host or remote host).

      Note The verification server version should be equal or above the version of the edition of the SQL server that is hosting the primary database.

    2. Select Load secondary locators to verify backups on secondary to verify your backups on secondary storage system.

    3. Select the policy for which you want to configure your verification schedule, and then select add policy from resourcegroup.

    4. In the Add Verification Schedules policy_name dialog box, perform the following actions:

      If you want to…​ Do this…​

      Run verification after backup

      Select Run Verification after Backup.

      Schedule a verification

      Select Run scheduled verification.
      Note If the verification server does not have a storage connection, the verification operation fails with error: Failed to mount disk.

    5. Select OK.

      The configured schedules are listed in the Applied Schedules column.

  6. In the Notification page, from the Email preference drop-down list, select the scenarios in which you want to send the emails.

    You must also specify the sender and receiver email addresses, and the subject of the email. If you want to attach the report of the operation performed on the resource group, select Attach Job Report.

    Note For email notification, you must have specified the SMTP server details either using the GUI or PowerShell command Set-SmSmtpServer.

  7. Review the summary, and then select Finish.

    The database topology page is displayed.

  8. Select Back up Now.

  9. In the Backup page, perform the following steps:

    1. If you have applied multiple policies to the resource, from the Policy drop-down list, select the policy that you want to use for backup.

      If the policy selected for the on-demand backup is associated with a backup schedule, the on-demand backups will be retained based on the retention settings specified for the schedule type.

    2. Select Verify after backup to verify your backup.

    3. Select Backup.

      Note You should not rename the backup job created in Windows scheduler or SQL Server agent.

      If the policy selected for the on-demand backup is associated with a backup schedule, the on-demand backups will be retained based on the retention settings specified for the schedule type.

      An implicit resource group is created. You can view this by selecting respective user or group from the User Access page. The implicit resource group type is “Resource”.

  10. Monitor the operation progress by selecting Monitor > Jobs.

After you finish

  • In MetroCluster configurations, SnapCenter might not be able to detect a protection relationship after a failover.

    Unable to detect SnapMirror or SnapVault relationship after MetroCluster failover

  • If you are backing up application data on VMDKs and the Java heap size for the SnapCenter Plug-in for VMware vSphere is not large enough, the backup might fail. To increase the Java heap size, locate the script file /opt/netapp/init_scripts/scvservice. In that script, the do_start method command starts the SnapCenter VMware plug-in service. Update that command to the following: Java -jar -Xmx8192M -Xms4096M.

Related information

Create backup policies for SQL Server databases

Backup operations fails with MySQL connection error because of the delay in the TCP_TIMEOUT

Backup fails with Windows scheduler error

Quiesce or grouping resources operations fail

PowerShell cmdlets
Steps

  1. Initiate a connection session with the SnapCenter Server for a specified user by using the Open-SmConnection cmdlet.

    Open-smconnection  -SMSbaseurl  https://snapctr.demo.netapp.com:8146

    The username and password prompt is displayed.

  2. Create a backup policy by using the Add-SmPolicy cmdlet.

    This example creates a new backup policy with a SQL backup type of FullBackup:

    PS C:\> Add-SmPolicy -PolicyName TESTPolicy
-PluginPolicyType SCSQL -PolicyType Backup
-SqlBackupType FullBackup -Verbose

    This example creates a new backup policy with a Windows file system backup type of CrashConsistent:

    PS C:\> Add-SmPolicy -PolicyName FileSystemBackupPolicy
-PluginPolicyType SCW -PolicyType Backup
-ScwBackupType CrashConsistent -Verbose

  3. Discover host resources by using the Get-SmResources cmdlet.

    This example discovers the resources for the Microsoft SQL plug-in on the specified host:

    C:\PS>PS C:\> Get-SmResources -HostName vise-f6.sddev.mycompany.com
-PluginCode SCSQL

    This example discovers the resources for Windows file systems on the specified host:

    C:\PS>PS C:\> Get-SmResources -HostName vise2-f6.sddev.mycompany.com
-PluginCode SCW

  4. Add a new resource group to SnapCenter by using the Add-SmResourceGroup cmdlet.

    This example creates a new SQL database backup resource group with the specified policy and resources:

    PS C:\> Add-SmResourceGroup -ResourceGroupName AccountingResource
-Resources @{"Host"="visef6.org.com";
"Type"="SQL Database";"Names"="vise-f6\PayrollDatabase"}
-Policies "BackupPolicy"

    This example creates a new Windows file system backup resource group with the specified policy and resources:

    PS C:\> Add-SmResourceGroup -ResourceGroupName EngineeringResource
-PluginCode SCW -Resources @{"Host"="WIN-VOK20IKID5I";
"Type"="Windows Filesystem";"Names"="E:\"}
-Policies "EngineeringBackupPolicy"

  5. Initiate a new backup job by using the New-SmBackup cmdlet.

    PS C:> New-SmBackup -ResourceGroupName PayrollDataset -Policy FinancePolicy

  6. View the status of the backup job by using the Get-SmBackupReport cmdlet.

    This example displays a job summary report of all jobs that were run on the specified date:

    PS C:\> Get-SmJobSummaryReport -Date '1/27/2016'

The information regarding the parameters that can be used with the cmdlet and their descriptions can be obtained by running Get-Help command_name. Alternatively, you can also refer to the SnapCenter Software Cmdlet Reference Guide.