Before Cloud Backup can protect your SQL Server databases, you must prepare the environment on the host server (ECS instance or on-premises). Complete the following tasks: verify the backup client prerequisites, set the recovery model, create a dedicated backup account with the required permissions, and enable network connectivity.
Step 1: Verify the Cloud Assistant Agent (ECS only)
The Cloud Backup client relies on Cloud Assistant Agent to communicate with ECS instances. Skip this step for on-premises servers.
Instances created on or after December 1, 2017: Cloud Assistant Agent is pre-installed. No action required.
Instances created before December 1, 2017: Install the agent manually. For instructions, see Install Cloud Assistant Agent.
Step 2: Set the recovery model to Full
Change the database recovery model to Full to enable log backups.
Open SQL Server Management Studio (SSMS) and connect to your SQL Server instance. To download SSMS, see Download SSMS.
In Object Explorer, right-click the target database and select Properties.
On the Options page, set Recovery model to Full, and then click OK.
Step 3: Create a backup account
Create a dedicated SQL Server login for Cloud Backup and assign the following roles:
| Role | Scope |
|---|---|
sysadmin | Server |
dbcreator | Server |
db_backupoperator | Database |
db_owner | Database |
Create the login
In SSMS Object Explorer, expand Security > Logins.
Right-click Logins and select New Login.
Configure the new login:
Set Login Name to backupadmin.
Select SQL Server Authentication.
Enter and confirm a password.
Clear the User must change password at next logon checkbox.
Assign server roles
On the Server Roles page, select sysadmin and dbcreator.
Assign database roles
On the User Mapping page, select the database to back up, then select the db_backupoperator and db_owner role memberships. Click OK.
Step 4: Enable mixed authentication mode
Cloud Backup connects to SQL Server by using SQL Server Authentication. Enable mixed mode so that both SQL Server and Windows credentials are accepted.
In SSMS, right-click the server object and click Properties.
On the Security page, select SQL Server and Windows Authentication mode and click OK.
Step 5: Enable TCP/IP
Cloud Backup communicates with SQL Server over TCP/IP. Enable this protocol in SQL Server Configuration Manager.
Log on to the server where the SQL Server instance resides.
Open SQL Server Configuration Manager.
In the left-side navigation pane, go to SQL Server Network Configuration > Protocols for MSSQLSERVER. Right-click TCP/IP and select Enable.
Restart the SQL Server service for the change to take effect.
What to do next
After you complete the setup, prepare the SQL Server database username and password, and then register the database with Cloud Backup: