返回
-
标题
Configure LiteSpeed backup with SQL proxy account -
说明
When security policies restrict access to the backup destination and requirements are not met for SQL Services backup/restore operations fail with error: "Backup of database "Database" failed. LiteSpeed for SQL Server could not open backup file: (Path to file)." -
原因
SQL Server and SQL Server Agent accounts need write access to the backup destination path.
Requirements -
解决办法
A proxy account with proper access can be procured and used to deploy LiteSpeed backup jobs.- Create a new SQL Server credential: Open SQL Server Management Studio expand Security->Right-click credentials-> click New Credential.
- Expand SQL Server Agent -> right-click Proxies -> click New Proxy
- Name the proxy and select credentials generated from step 1.
- Activate CmdExec subsystem
- Refresh the node and the Proxy should show up under Operating System
Deploy LiteSpeed backup jobs to run with the proxy account.
- Open the LiteSpeed console
- Select Backup or Multi-Database Backup based on the requirements
- Configure the backup template
- On the execute Script step click Preview CMD Line Script
- Copy the script and cancel the wizard
- Open Job Manager
- Rich-click the instance and create New Job
- Name the job
- Add Step 1 and name it
- Set step type to CmdExec
- Set the step to Run as the configure proxy account
- In the statement field paste the copied content from the backup wizard
- Add the path to the executable at the beginning. The default is "C:\Program Files\Quest Software\LiteSpeed\SQL Server\Engine\SQLLiteSpeed.exe"
- Set schedule, alerts and other configurations as needed
- Save the job