File Permission Requirements for SQL Database Backup in Shavlik Protect

Version 2

    Purpose

     

    This document provides an explanation of what file permissions need to be in place to successfully perform database backups through the database maintenance features of Shavlik Protect.

     

     

    Description

     

    In the Database Maintenance menu under Tools > Operations, Shavlik Protect allows administrators to perform database backups as part of their database maintenance process. In order to do so, administrators must provide a file path for the local database directory or a UNC path for the remote location.

     

    dbbackup.PNG

     

    When administrators configure this process to run as a part of their database maintenance, the console sends a command to the SQL service to perform a DB backup to that path. What this means is that in order to ensure that the SQL server can perform a backup of the SQL server when prompted by the console, the account the SQL server service runs under needs read/write access to the file directory designated in the above menu (in this example C:\dbbackup).

     

    permissions.PNG

     

    Administrators can either specifically provide the read/write rights to the directory for the SQL account, or they can grant the privileges to the authenticated users group which should include the default SQL service account.

     

     

    Additional Information

     

     

    To determine the account the SQL service runs under perform the following on the machine that hosts the database :

    Click Start > Run and type services.msc and hit Enter.

    Locate the SQL Server service and Right-click on it and select Properties.

    Select the Log On tab, and next to "This account" there should be an account listed- this is the account the SQL service uses and which needs rights over the file directory of the backups.

    SQL account.PNG

    In this case this account is "NT Service\MSSQL$SQLEXPRESS"

     

    Affected Product(s)

     

    Shavlik Protect 9.x