Preparations

Step 1: Get the required information

1. If you back up a database on an ECS instance, install Cloud Assistant for the instance.

   The ECS backup client works in conjunction with Cloud Assistant.

   • If the ECS instance was purchased before December 1, 2017, you must install the Cloud Assistant client. For more information, see Install the Cloud Assistant client.

   • If the ECS instance was purchased after December 1, 2017, the Cloud Assistant client is installed by default.

2. Obtain the username and password for the SQL Server database.

Step 2: Create a backup account and configure permissions

1. Log on to the SQL Server database using SQL Server Management Studio (SSMS).

   To download and install SSMS, see Download SQL Server Management Studio (SSMS).

2. Set the database recovery model to Full.

   Important

   Log backups require the recovery model to be set to Full.

   1. Right-click the database that you want to modify and select Properties.

   2. On the Options page, set Recovery model to Full and click OK.

      The following figure uses SQL Server 2008 R2 as an example.

3. Create a SQL Server user for backups.

   1. Create a new logon in SSMS.

      1. In Object Explorer, expand Security > Logins.

      2. Right-click Logins > New Login....

      3. Set Login name to backupadmin, select SQL Server authentication, and then enter and confirm a password.

      4. Deselect the User must change password at next logon check box.

         The following figure uses SQL Server 2008 R2 as an example.

   2. On the Server Roles page, grant the sysadmin and dbcreator roles to the account.

      The following figure uses SQL Server 2008 R2 as an example.

   3. On the User Mapping page, select the databases to back up, select the db_backupoperator and db_owner database role memberships, and then click OK.

      The following figure uses SQL Server 2008 R2 as an example.

4. Enable SQL Server and Windows Authentication mode.

   1. Right-click the server object and click Properties.

   2. On the Security page, select SQL Server and Windows Authentication mode, and then click OK.

Step 3: Configure the network

1. Log on to the server where the SQL Server database is deployed.

2. Enable the TCP/IP protocol in SQL Server Network Configuration.

   1. Open SQL Server Configuration Manager.

   2. In SQL Server Configuration Manager, navigate to SQL Server Network Configuration > Protocols for MSSQLSERVER. Right-click TCP/IP and click Enable.

      The following figure uses SQL Server 2008 R2 as an example.

   3. Restart the SQL Server service.

References

• What is Cloud Backup?

• Database Backup FAQ

• When I back up an SQL Server database, are all backups uploaded to the cloud? Are any backups saved locally?