You can set up SQL server for backup after you have completed the initial configuration. Initial configuration includes:
- Creating/selecting an organization: In Phoenix, Organization is an access-based control mechanism to configure the servers for backup and restore. Organizations create a logical partitioning of the entities, such as servers, backup policies, retention policies and so on. Phoenix provides a default organization (called Default Site) that you can select and register your servers.
- Creating administrators: Administrators are users that control server registration and configuration for backup and restore.
After the initial configuration is complete, perform the following steps to let Phoenix back up databases created and managed using MS-SQL server.
Steps to set up Phoenix to back up databases
|Prepare your SQL servers for backup|
|1||Log on to Phoenix Management Console and select an organization to register a server.||From the Phoenix management console, select an organization in which you want to register a SQL server.
Use the Register New Server option from the Servers tab of the selected organization to download the Phoenix agent and generate the activation token.
|Register and configure your SQL servers for backup|
|2||Register your server||Go through the prerequisites, install the Phoenix agent on the system that hosts SQL server instance(s), and activate the agent using the activation token. When you activate your agent, you provide a server name for the system on which the agent is installed. Your system is registered with the server name you provide. To see your server, log on to Phoenix management console, select your organization and then click Servers. You can see your server under the Registered tab.|
|3||Configure your server for backup||Select your server, and attach it to a server group. Backup and retention policies specified for the server group are applied to your server. You can:
Backup policies specify the backup content, backup schedule which defines when a backup job should get triggered, and the bandwidth available to the agent to execute a job.
|Back up databases|
|4||Agent triggers backup based on backup policy||Phoenix agent triggers a backup job based on the schedule you specify in the backup policy. When a full or differential backup job is triggered, Phoenix backs up the selected database, and its snapshot is created. When a log backup is triggered, transaction log of the database is backed up.|
|5||Trigger restore from the Phoenix Management console||When you require a recovery, you trigger a restore job from the Phoenix management console. Phoenix lets you perform the following restore jobs:|