Backing up SQL server 2005

[Arc_1]

Hello,

I have a server which I would like to backup using Netbackup. Its running a SQL server 2005 database.

What backup agents do I require?

Can I use just a standard netbackup client for Windows or do I need to purchase an advanced client or more

Any advice appreciated

C

[DavidParker]

Standard Client is fine.
You will probably want the MSSQL Agent (activated on your master server with a license key).

There are 2 ways to do SQL backups:
1) Use the Agent and write directly from SQL to tape
2) Use SQL to dump your db's to disk and then backup the disk to tape (can be scripted from inside SQL)

Here are the Reference Manuals for SQL backups for various versions:


268190: VERITAS NetBackup (tm) 5.1 for Microsoft SQL Server System Administrator's Guide for Windows
 http://support.veritas.com/docs/268190


279277: VERITAS NetBackup (tm) 6.0 for Microsoft SQL Server System Administrator's Guide
 http://support.veritas.com/docs/279277


290212: Veritas NetBackup (tm) 6.5 for Microsoft SQL Server Administrator's Guide
 http://support.veritas.com/docs/290212

[Arc_1]

Hi David,

Thanks for the inofrmation, thats very helpful. I will take a look at the docs for more understanding.

Its appreciated

C

[DavidParker]

No problem!

If you have any other questions, concerns, etc, just come on back :)

If I'm not able to help, I'm sure there are plenty of other folks who can!

[Colin_North]

As David has mentioned the standard client is fine for this, you just need to get a license key to activate the SQL DB agent feature. Make sure when you purchase your license and support certificate you get the right one, they are licensed on the number of physical processors you have in your SQL box:

* Tier 1 is for 1 CPU

* Tier 2 for 2-3

* Tier 3 for 4-7

* Tier 4 for 8 and more

You need to speak to your Netbackup sales person for more info.

One note if you are using Netbackup 5.0, you'll need MP7 to backup SQL 2005 databases directly, NBU 6.0 is fine.