You can set up SQL server for backup after you have completed the initial configuration. Initial configuration includes:
- Creating or 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 your SQL server and configure databases 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 you install the agent and register the system with this server name. 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. Apply backup and retention policies specified for the server group to your server. You can:
Backup policies specify the backup content, the 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 you trigger a full or differential backup job, Phoenix backs up the selected database based on the content rule and creates a snapshot. When a log backup is triggered, the 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:|