How to Backup/Restore SQL 2000 Cluster using BE8.6?

[mikesu]

Sir,
Someone can tell me that how to backup/Restore SQL 2000 Cluster using Backup Exec 8.6.
The environment below,
Having one backup server with DDS3 Tape(already install BE8.6).
The two nodes(SQL 2000 Cluster) are already install client agent and sql agent.
That all.
Please help me...Thanks.

 

[SQLBill]

I have a 2-node Win2K Advanced Server with MS SQL Server 2000 on two arrays and am using Veritas BE 8.6.

First...which BUILD are you using? Go to Help, right-click and select About Backup Exec...at the top of the pop-up window it will tell you the version. The 'revision' number is the same as the build. You should have 3878.

Second...in the same window, how many and which licenses does BE show you have? For a 2-node cluster, you should have:

Advanced Server Edition - 1 copy
SANS Shared Storage Option - 1 copy
Library Extension Option - 1 copy
Remote Agent for Windows - 2 copies
Agent for Microsoft SQL Server - 2 copies
Cluster Option - 1 copy

Advanced Server Edition and Cluster Option are really the same things, they are Veritas BE 8.6 Advanced Server Edition. You need two copies of that and when you input both licenses, the names and license numbers change.

Also, there is an issue with the SQL Agent under certain circumstances. I'll get a list of those and post them for you. If you meet the criteria, BE 8.6 SQL Agent won't really work unless you apply the HOTFIX 4.

-SQLBill

 

[SQLBill]

Check out this thread: thread481-413848
also Technote 246346 on Veritas' web site.

But basically, if you meet the following:

-- SQL and Backup Exec were installed on multi-processor servers.
-- SQL was installed as a cluster aware application.
-- Backup Exec was installed either as a cluster aware application or on an individual node on the cluster (a non-cluster aware installation).
-- SQL and Backup Exec were both active on the same node at the same time the backup was performed.

You MUST have BE 8.6 Build (version) 3878 and HOTFIX 4 applied. If you don't have that Build and HOTFIX applied, you can backup all you want, but you can NEVER restore your database if you are using the SQL Agent.

I don't use SQL Agent to backup my databases. I use the native SQL Server BACKUP DATABASE commands to backup to disk (.bak files) and then copy those files to tape with BE.

-SQLBill

 

[mikesu]

Thanks for your info.
The Environment below,
The Backup Server only install Veritas BE v8.6 3878 no any fixed.
The tow-node cluster, only install client agent and sql agent in each one.
The SQL cluster is based on IBM Clustering(two servers and one diskarry[SCSI]).
The Backup Server can find sql server from Virtual SQL Server.
Testing Procedure,
Backup Method,
1st,
Select SQL Server's DB from Virtual SQL Server, then Select "Backup"-->"SQL"-->"Backup Method for database-->Database-Bakc Up Entire Database"
2nd,
Add records into database[LabDB].
3rd,
"Backup Method for database-->Log-Back Up Transation Log"
4th,
Add records into database[LabDB].
5th,
"Backup Method for database-->Log-Back Up Transation Log"
Restore Method,
1st,
"Database Recovery Method(v7.0 or later)-->No Recovery;Fully database", It's Successfull.
2nd,
"Database Recovery Method(v7.0 or later)-->Recovery Database;First Transation Log", It's Successfull.
3rd,
Check SQL database[LabDB] is OK.
4th,
"Database Recovery Method(v7.0 or later)-->Recovery;Second Transation Log", It's Failed.
Failed Log is below,
"SQL Server returned the following error message: The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step."
Why ???? Someone tell me how to slove it.
Thanks.

 

[SQLBill]

When you do a SQL Server restore, you do one of two things depending on how many files you are restoring.

1. If all you have is a FULL Backup, you restore that file.

2. If you have additional files, Differential and/or transaction log backups; then you must first restore the Full Backup WITH NORECOVERY and each additional file must be WITH NORECOVERY except for the very last one.

WITH NORECOVERY tells SQL Server that there are more files to be restored before the database is completely restored.

Using Veritas BE for the restore, go to the SQL tab and make sure that "Database recovery method" is set for "No recover" on every restore except for the last one which should be set to "Recover". Remember, this is per database.


-SQLBill

 

[mikesu]

Hi, SQLBill
Thanks for your explain...
The means that don't care how many differential and/or Transation Logs.
For each database restore, must first resotre the full backup and restore each additional file with "Norecovery".
Final, restore last Transation Log(which you want) with "Recovery".
Above is right ?

Last, The below Configuration is right?
Backup Server only install Veritas BE8.6 3878.(Must be SP4 patch?)
The client agent and sql agent are install each noeds(NodeA and NodeB).

 

[SQLBill]

The first part is correct.

The second part, you need HOTFIX 4. That's what it is called on Veritas' Webpage. Other wise, your configuration is correct.

By the way, there are instructions on Veritas' webpage for installing on a cluster.

-SQLBill

 

[mikesu]

Hi, SQLBill,

Today, I follow your info restoring sql 2000 db. It's successfull. I am so glad...

But, not install hotfix 4 in backup server. However, I am so glad...
Finally, Thanks for your info. Thanks.

SQLBill is NO 1....