1. On the Cell Manager server, start the Data Protector installation and accept the license agreement.
2. Select Cell Manager as the Installation type. Figure 14 shows the installation type.
Figure 14. Data Protector installation type
3. Enter the appropriate username and password.
4. Select the installation path.
5. Select the components you want to install on the Cell Manager and click Next. For testing, we use the default settings. Figure 15 shows the component selection screen.
Figure 15. Data Protector Cell Manager component installation
6. Download and install on Cell Manager all necessary Data Protector patches from the patch download site at http://h20000.www2.hp.com/bizsupport/TechSupport/
DriverDownload.jsp?prodNameId=3241177&lang=en&cc=us&taskId=135&prodClassId=
1&prodTypeId=18964&prodSeriesId=3241176.
7. Start the Data Protector GUI.
Adding clients
1. Select Add New Clients from the pop-up window.
2. Right-click Clients in the scoping pane (the tree menu on the left part of the window), and select Add Clients. Figure 16 shows how to add clients.
Figure 16. Adding clients
3. Browse to each of the servers you need, including the virtual name for the SQL Server (not just the physical box that it is on) and click Add. When added, the servers are listed under Client Systems. Figure 17 shows how to add servers.
Figure 17. Added servers
4. Click Next and select the components to be installed on all of your servers, or click I want to customize these options for client systems independently (below the component list). Figure 18 shows how to customize client systems. Figure 19 shows how to install specific components on each server.
Figure 18. Customize options for client systems
Figure 19. Adding server components
• HP customizes components for each server. Table 4 shows the installed modules. If you choose to customize servers, keep the following information in mind:
– The modules specific to SAP integration are not used for MS SQL Server, so do not include those.
Table 4. Modules installed
Installed modules Functions Location
Disk Agent For each system involved in data backup Every server Media Agent For the server in the same enclosure
quadrant as the tape blade or that is connected to other necessary backup media
Management server, because it is in the same quadrant as the tape blade
User interface For the server used for managing Data Protector
Management server with Solution Manager, Command View, and Data Protector Cell Manager
MS SQL 7.0/2000 Integration
For all servers acting as SQL clients or servers
Both servers in the production system and the test/QA and development servers
Figure 20 lists the Data Protector server components.
Figure 20. Data Protector server components
Adding devices
1. Select Devices & Media from the context list.
2. In the scoping pane, under Environment, right-click Devices and select Autoconfigure Devices.
Figure 21 shows how to set automatic configuring of devices and media.
Figure 21. Automatically configuring devices and media
3. Select the client server with access to the backup device.
4. Select the device found (in this case, HP:Ultrium 2-SCSI) and click Finish. Figure 22 shows how to add devices.
Figure 22. Adding devices
5. Expand Media in the scoping pane.
6. If the devices do not appear, right-click Pools and select Add Media Pool.
7. Provide a pool name, select the media type (we selected LTO-Ultrium), and finish creating the pool.
8. Right-click on the media pool you created and select Format. Figure 23 shows how to format media.
Figure 23. Formatting media
9. Select the device to format and click Next.
10. Provide a name for the media and click Next.
11. If the media has been used before, you may need to click the Force operation check box. Click Finish. Figure 24 shows where to select Force operation.
Figure 24. Force operation
Your system is now ready to create backups.
Set up and use SQL Server backup
1. Select Backup from the context list.
2. Expand Templates, right-click MS SQL Server, and select Add Template.
3. Select the backup device, make sure Load Balancing is not selected, and click Properties.
• If you have only one backup device, load balancing will have no effect regardless of the selection.
• For a small SAP landscape similar to that used in this project, HP does not recommend using load balancing unless you are using multiple device streaming. This is because you may wish to explicitly select where backup objects are stored, and because you will likely be backing up only a few items.
• For more information about device lists and load balancing, see the HP OpenView Storage Data Protector Concepts Guide at http://bizsupport.austin.hp.com/bc/docs/support/
SupportManual/c00751562/c00751562.pdf.
Figure 25. Creating a backup template
4. From the Device Properties window, select the media pool you wish to use and click OK.
5. Click Next, set any other optional changes, and then click Next. (Default settings were used in testing.)
6. Set up a schedule (optional) and click Next to save the template.
7. Create a backup specification by expanding Backup Specification. Figure 26 shows how to select databases.
8. Right-click MS SQL Server and select Add Backup.
9. Select the backup template you just created.
10. Select Local or network backup, clear Load balanced, and click OK.
11. Under the Application section, and from the Client menu, select the name of the SQL Server (not the physical server that the database resides on, but the name of the virtual server managing your database). Click Next to continue.
12. If an authentication window pops up, use Integrated Security if using a domain account with access to the database, or select Standard Security to use a database user.
13. Select the databases you wish to back up, and then click Next.
Figure 26. Selecting databases to back up
14. Make selections on subsequent screens, as you did when setting up the template.
15. Save the backup specification. You are now ready to back up your database.
16. Right-click the backup you just created in the scoping pane, and click Start Backup.
17. Select the backup type to create and click OK.
Note
Differential and transaction log backups are an option only if a full backup already exists.
Restore SQL Server
Note
To maintain data consistency in the database, SQL Server requires that there be no active connections to the database.
Therefore, before restoring your data, you must shut down all SAP instances with connections to that database.
1. Select Restore from the context list.
2. Expand the MS SQL Server list to display the backed-up databases.
3. Select the components to restore. For simple SAP system restorations, select only your primary system database. Figure 27 shows where to select components to restore.
4. Right-click the name of the database and click Properties.
Figure 27. Restoring SQL database files
5. Select the backup version you wish to restore from and click OK. If you select a transaction log backup, you can restore to a specific point in time. Figure 28 shows where to select a backup version.
Figure 28. Selecting a backup version
6. Click Restore to start restoring your database.
Set up and use file system backup
1. Select Backup from the context list and expand Templates. Figure 29 shows where to select the file system backup file.
2. Right-click Filesystem and select Add Template.
3. Select the backup device, clear Load balancing, and click Properties.
4. Select the media pool to use and click OK.
5. Click Next and give the backup a description.
6. Select the protection level, apply a filter (optional), and then click Next.
7. Set up a schedule if necessary, and save the template.
8. Expand Backup Specifications, right-click Filesystem, and click Add Backup.
9. Select the template you created, clear Load Balanced, and then click OK.
10. Select what to back up and then click Next. You can select volumes, folders, and files.
Figure 29. File system backup file selection
11. Select the appropriate backup device and media pool, and then click Next.
12. Continue clicking Next to use default settings and save the backup.
13. In the scoping pane, expand Filesystem and select the backup specification you created to make changes, or right-click the backup and select Start Backup.
14. Select the backup type and start the backup.
Note
A full backup must exist before incremental backups can be created.
Restore the file system
1. Select Restore from the context list. Figure 30 shows the file system restore feature.
2. Expand Backup Specifications and Filesystem.
3. Select the backup specification from the scoping pane, and then select the volumes, folders, or files you wish to restore.
4. Right click a volume and select Restore Version.
Figure 30. File system restore
5. Select the file system backup version to restore and click OK.
6. Click Restore.