Downtime for installation?

kingrudedog · September 29, 2010 9:40AM

Any downtime required for cluster install for SQL Backup 6?

Any restart of SQL Server required?

Thanks.[/u]

petey · September 29, 2010 12:20PM

A SQL Backup cluster installation entails the following:

- installing the SQL Backup server components on both the active and passive nodes
- setting up the SQL Backup Agent service as a cluster resource in the SQL Server cluster group
- registering the SQL Backup extended stored procedures on the clustered SQL Server instance

Assuming your cluster is 'normal', for a new installation, all the above activities do not require a reboot of the machine nor a restart of the SQL Server instance.

For an upgrade, you may need to bounce the SQL Server instance if the extended stored procedures cannot be replaced, usually because SQL Server does not release the library from its process space. This is more common on SQL Server 2000 instances.

kingrudedog · September 29, 2010 4:21PM

Doesn't each node have a copy of the SQLBackupAgent?

In making it a cluster resource, do you mean making it critical to the cluster, so if it fails, the cluster fails over?

petey · September 29, 2010 8:22PM

Doesn't each node have a copy of the SQLBackupAgent?

Yes, each nodes requires a SQL Backup Agent service running. And your point being?

In making it a cluster resource, do you mean making it critical to the cluster, so if it fails, the cluster fails over?

Actually, the SQL Backup cluster resource by default is set up so that it does not fail over the entire cluster. After installation, you should run it for a few days or so to check that everything's in order, before deciding to make it a critical resource.

Downtime for installation?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk