Read CA ARCserve Backup r12 - Database and Catalog text version

CA ARCserve Backup r12 - Database and Catalog

CA ARCserve Backup r12 uses Microsoft SQL Server 2005 Express Edition and Microsoft SQL Server 2000/2005 Standard and Enterprise editions as database. The upgrade process from previous versions of CA ARCserve which used proprietary backend database (Raima) to the new database is automated and seamless. As the amount of information and data that is created increases, the backup jobs that are used to ensure their security also grow larger. As a result, the amount of time needed to parse or analyze this information could become very timeconsuming and has a negative impact on the performance of the system. To resolve this, CA introduced Catalog Database and Catalog Browsing in CA ARCserve r12. When CA ARCserve performs a backup, all the job, session, and media information is loaded into a database. A separate catalog file is created under the catalog database folder with information about each session. Catalog files do not need to be loaded or merged into the database for recovery or browsing, increasing the access speed to catalog information.

Overview

CA ARCserve Backup r12 stores information about the jobs run, the media used for backups, and the devices used for backups on the database. CA ARCserve uses Microsoft SQL Server 2005 Express Edition as a default database, which is more scalable and reliable than previous versions. CA ARCserve also supports Standard and Enterprise Editions of SQL Server 2000/2005. The CA ARCserve catalog database helps you manage multi-server environments. You can browse media information or generate reports for multiple servers at the same time. ·

Benefits

Enhanced security, Advanced query optimizer, Reporting services, Scalability and Performance, Automated Tuning, Stored procedures, Snapshot isolation level, and Full Text Search. Backup administrators can set automated catalog and database pruning policies, and maintenance tasks which removes older information. Database upgrades are now seamless and easy to do for customers who outgrow their existing database. Automated pruning policies and maintenance tasks further increase scalability and manageability.

·

·

·

Install/Configure

CA ARCserve r12 ships with Microsoft's SQL Server 2005 Express Edition on the installation media. Microsoft SQL Server 2005 Express does not support remote operations; you must install the CA ARCserve database locally on to your CA ARCserve Backup server. If SQL Server Express already exists before CA ARCserve installation, then CA ARCserve prompts to create another instance of the database. Member servers use RPC to communicate with SQL Server Express on Primary server; the Primary server uses ODBC to communicate with the local SQL Server Express. Alternatively, you can also use your existing licensed versions of SQL Server 2000/2005, including Standard and Enterprise Editions as a database for CA ARCserve. SQL Server could be remote or local. Primary server and Member servers use ODBC to communicate with the database. For higher levels of scalability, SQL Server 2005 editions are also available on a 64 bit platform. CA ARCserve does not support migrating data from a Microsoft SQL Server database to a Microsoft SQL Server 2005 Express database. In CA ARCserve r12, the Catalog Database and Catalog Browsing features are enabled by default. After upgrade DB protection job is automatically added to the job queue which takes backup of the ARCserve database. In r12 as part of Database Pruning job different database maintenance operations like Update Statistics, Rebuild Indexes, Check DB integrity and Reduce DB size can be performed. These database maintenance operations can also be done independent of Database pruning job by using Job Scheduler wizard to create individual jobs that use ca_dbmgr command line utility to facilitate the database maintenance operations.

Deployment Scenarios

The below illustration depicts the different scenarios in which you can install and manage your CA ARCserve database and catalog database:

Local DB: Microsoft SQL Server or Microsoft SQL Server Express

ARCserve DB Catalog DB

Standalone Server

Remote DB: Microsoft SQL Server

Standalone Server

Catalog DB

ARCserve DB

Central Management

Local DB: Microsoft SQL Server or Microsoft SQL Server Express

ARCserve Domain Primary ARCserve DB Catalog DB

Remote DB: Microsoft SQL Server

Central Management

ARCserve Domain Primary

Catalog DB

ARCserve DB

ARCserve Domain Members

2

ARCserve Domain Members

How Catalog Database works

CA ARCserve Backup queries the catalog files with the help of the catalog index instead of querying the content of the entire database when you need to check for a directory or file to be restored, or to get the version history, or to perform a search. If catalog browsing finds the details in the catalog database folder for a specific session, it will not look in the CA ARCserve Backup database. However, if it does not find it, it will then attempt to look in the CA ARCserve Backup database. CA ARCserve Backup periodically checks the free disk space percentage on the volume where the catalog database folder is located. If the detected free space is lower than the specified percentage, a warning message will be sent to the activity log and it would automatically begin to delete catalog database files from the disk until the detected free space percentage is greater than the threshold setting.

Frequently Asked Questions

Q: A: Can I perform maintenance tasks on the SQL Server Express database using CA ARCserve? Yes, you can perform maintenance tasks on the SQL Server Express database from CA ARCserve r12 Manager User Interface. How does Catalog Browsing work? Catalog DB and Catalog Browsing are enabled by default in CA ARCserve r12. Two index files are created for each catalog file under Catalog DB folder with .abd and .abf extensions. The .abd contains directory info and .abf contains file info and both of them internally point to the content of catalog files under Catalog DB.

Q: A:

Summary

The CA ARCserve Backup r12 creates a catalog file to store information about each session, catalog files do not need to be loaded or merged into the database for recovery or browsing. The central catalog database helps you manage enterpriselevel, multi-server environments. You can browse media information or generate reports for multiple servers at the same time. To get maximum value from your investment in CA software, CA Education can help you get the right training for your unique challenges. Visit http://ca.com/education for additional information.

Copyright © 2008 CA. All rights reserved. All trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.

Information

CA ARCserve Backup r12 - Database and Catalog

2 pages

Report File (DMCA)

Our content is added by our users. We aim to remove reported files within 1 working day. Please use this link to notify us:

Report this file as copyright or inappropriate

652657


You might also be interested in

BETA
CA ARCserve Backup r12 - Database and Catalog
CA ARCserve Backup r12 - FAQsV2
BrightStor ARCserve Backup for Windows Administrator Guide