The best way to backup MS SQL?

Question

What is the best way to backup clustered MS SQL Server 2000 and 2005? Is the type of cluster (local or geographically dispersed) important for backup solution?

amediratta · Answer

You can choose for some solution like EMC Networker which are cluster aware and can take online backup of your databases.

Roman4 · Answer

Actually I can't backup virtual MS SQL Server using NW with MS SQL module. I can backup only physical nodes instead.

amediratta · Answer

Why so? I believe NW should backup the virtual node as well. Any specific problem you are facing.

mofo · Answer

Hi,for backup you need to know the 'Network name' resource value for virtual SQL server (check your Cluster Administrator), define that Network name as a NetWorker client, set the Backup command for that NetWorker client to nsrsqlsv -a , know any named instances of virtual SQL server, define them in 'Save Sets' field for this new NetWorker Client and you're on your way... best regards Mladen

Replication Manager

The best way to backup MS SQL?

Was this post helpful?