Performing Integrated Restore Jobs › Restore Using Arcserve Backup › Restore Microsoft SQL Server Database to Master Machine

Restore Microsoft SQL Server Database to Master Machine

When restoring a Microsoft SQL Server database to the Master server with Arcserve Backup, you may receive a "Windows could not start the SQL Server" error if running SQL Server 2008. (This error does not affect SQL Server 2005 restore jobs.) This error is caused by the Network Service or Local Service accounts, which do not have access rights to the SQL log file on the Master.

There are three ways to avoid this issue:

• In Arcserve Replication and High Availability, set the scenario Replicate ACL option to On. Doing so guarantees that all ACL information for the Master SQL data directories are retained after recovery, allowing the SQL service to operate.
• In Arcserve Backup, manually add the following user account after recovery to the ACL of the SQL data directories on the Master: SQLServerMSSQLUser$Computer Name$Instance Name
• In Arcserve Backup disable the following restore option to NOT overwrite the ACL of the SQL data folders on the Master after restore: Arcserve Backup Manager, Global Options, Operation. Click to enable or disable the option, Restore and Preserve File Attributes and Security Information. Checking this option overwrites the ACL. Clearing the option does NOT overwrite the ACL.