How to backup SQL2000

[diane_walker]

We are running BackupExec 10.0. We also purchased BackupExec SQL Agent. We have SQL 2000 Enterprise Edition running on Windows 2003 Standard Edition server. What would you recommend the method to backup SQL2000? Thanks.

[Sam_Gooble]

We use SQL Server native backup which is online, means can run without affecting existing SQL processes. What we do is backup SQL using its native backup and put it on a network share. backup on SQL can get trickier, your DBA is the best to answer that. it all depends upon how much data loss can you afford? transactional backup can get you the most recent data, provided you schedule FULL, Differential and transactional backups in an appropriate sequence.

[diane_walker]

Thanks for your quick response. Can you verify my understanding? So, you do two backup jobs by using SQL backup. One is to backup the database. The other one is to backup the transaction log. For the transaction log, you do full and differential back-ups.

Thanks.

[Gauri_Ketkar]

Hallo,

If you have SQL database running on another server,install SQL Agent on Backup Exec media server and push install remote agent to the remote SQL server.

How to install Backup Exec components through the Additional Options feature
http://seer.support.veritas.com/docs/253168.htm

How to perform a FLATFILE and ONLINE backup of SQL 2000 server using Backup Exec
http://seer.support.veritas.com/docs/272834.htm

Step by step installation instructions for the Backup Exec Agent for Microsoft SQL
http://seer.support.veritas.com/docs/235680.htm

Also refer the Administrators Handbook for further Information :

VERITAS Backup Exec (tm) 10.0 for Windows Servers Administrator's Guide (English)
http://seer.support.veritas.com/docs/269777.htm
page number - 1061


Thank you,
Gauri

Additional Information :
For information on the recent VERITAS Backup Exec security vulnerabilities, including links to the downloads for the necessary hotfixes, please refer to the following document:
Patch summary for Security Advisories VX05-001, VX05-002, VX05-003, VX05-005, VX05-006, VX05-007

http://seer.support.veritas.com/docs/277429.htm



NOTE : If we do not receive your reply within two business days, this post would be marked "assumed answered" and would be moved to "answered questions" pool.