Data Protector Express User Guide (TC330-96005, September 2011)
Table Of Contents
- User Guide
- Contents
- 1 Overview
- 2 Administering Backup
- 3 Configuring Backup Jobs
- 4 Configuring Restore and Verify Jobs
- 5 Working With Devices
- 6 Scheduling, Rotations, and Media Management
- 7 Encryption and Compression
- 8 Working with Third-Party Applications
- Microsoft Exchange Server
- Working with Microsoft SQL Server
- Microsoft SQL server concepts
- Configuring the Microsoft SQL Server
- Backing up Microsoft SQL Server
- Restoring Microsoft SQL Server
- Restoring Microsoft SQL Server user databases
- Restoring Microsoft SQL Server master databases
- Restoring Microsoft SQL Server 2000 master databases
- Restoring Microsoft SQL Server 7 master databases
- Protecting Microsoft Windows SharePoint Services
- Working with Certificate Services
- 9 Disaster Recovery
- 10 Backup Domain Configuration
- 11 Advanced Job Options
- 12 Support and other resources
- Index
Supported platforms
The Data Protector Express Agent for Microsoft SQL Server supports Microsoft SQL Server 7 and
Microsoft SQL Server 2000.
Some editions of Data Protector Express do not provide a license to backup Microsoft SQL data.
By default, an evaluation version of the Data Protector Express agent is installed automatically
when you install Data Protector Express on each Windows server. You can use this evaluation
license for 60 days. To continue using the agent, contact your sales representative to purchase an
edition of Data Protector Express that supports Application agents.
Microsoft SQL server concepts
Microsoft SQL Server environments are frequently mission critical and must be maintained 24 hours
a day, seven days a week. Procedures and plans must be in place to ensure the quick recovery
of data in the event of data loss.
Using the transaction logs associated with each database, you can quickly recover your databases.
Transactions that were not committed can be rolled back, while transactions that were committed
can be written to disk.
While transaction logs assure that only committed transactions are written and restored, to use
them correctly, you must have a comprehensive backup plan that regularly backs up these logs.
Additionally, when you reconstruct a database, you must restore the database files and logs using
only the procedures set out below.
Configuring the Microsoft SQL Server
You can configure any Data Protector Express feature by selecting the object from the Catalog
view and updating information on its property pages.
1. Select the Administration desk bar and open the Catalog view.
2. Select Network, and then select the Microsoft SQL Server on your system.
3. Expand the object until you see a list of database instances.
TIP: Switch to the Folders view to display a hierarchical tree of the Data Protector Express
management domain.
4. Right-click the database instance and display its property pages.
50 Working with Third-Party Applications