Legacy SQL Server agent
The SQL Server agent allows for the fast, flexible, and reliable archive and restore of Microsoft SQL Server databases. This feature allows system and database administrators the ability to backup and restore mission-critical databases, manually or automatically, while ensuring business continuity.
The SQL Server Browser service must be running for proper execution of the SQL agent. The following SQL Server agent versions have been tested and certified with Server environments running Windows 2000 or Windows 2003 and Microsoft SQL Desktop Engine (MSDE) 2000:
|
•
|
Microsoft SQL Server Express 2005 |
|
•
|
Microsoft SQL Server 2000 |
|
•
|
Microsoft SQL Server 2005 |
The following SQL Server Agent versions have been tested and certified with Server environments running Windows 2003 or 2008:
|
•
|
Microsoft SQL Server 2005 |
|
•
|
Microsoft SQL Server 2008 |
The following requirements must be fulfilled before installation of the legacy SQL Server agent:
|
•
|
SQL 2000 Service Pack 4 |
|
•
|
SQL 2005 Backward Compatibility Update |
For Microsoft SQL Servers configured for failover clustering, Unitrends recommends using Microsoft SQL maintenance plans for database backups. Microsoft SQL maintenance plans should be directed to a local disk and scheduled prior to a Unitrends file-level backup. Unitrends file-level backups can subsequently protect these database backup files and provide online retention.
The SQL Server agent contains the following functionality:
|
•
|
Ability to determine database backup strategies based on user supplied recovery requirements. |
|
•
|
Ability to generate database backup schedules using a wide variety of frequency options to accommodate daily, weekly and monthly backups. |
|
•
|
Availability of default database backup templates consisting of some of the most common backup practices. |
|
•
|
Simplified restore process allowing for the restore of a single database or multiple databases. |
|
•
|
Support for point-in-time recovery. |
|
•
|
Support for restoring a database to an alternate database name. |
|
•
|
Support for full, differential, or transaction log backups. |
|
•
|
Ability to view backup and restore history. |
|
•
|
Support for restoring a database to an alternate location. |
Note: When using the SQL Agent to backup up databases, other backup applications should not be used to backup databases. This will cause problems when restoring the database, especially when restoring transaction logs.
Please do not use the Unitrends SQL Server agent to backup SQL Server 2000 databases using full-text catalogs and indexes.