Usually you would not have to use '-c' option if you do not have problems with indexes, but you can use it if you want.

Take a look at the Nw module for SQL manual about users and permissions you may need to set to do the backup.

After that, go ahead!

You will probably wish to define directive to skip db files that are covered by module online backup.

My understanding is that you backup the system files of both your PNodes and only the shared data on your VNode ( i.e. only the DBs).

Hi Daniel,

Thanks for your reply. In our case SQL DBA wants to kick off the backups from his side using "nsrsqlsv". In this case I want know as how many instances should I have exactly add to accomplish this task ?

Is it like 2 P-Nodes and 1 V-Node etc ?

Thanks

Yes, 2 pnodes and 1 vnode. Even if you're only going to run manual backups, have these configured.

Thank you very much.

Hi bkppkb,

if you're using your virtual node to backup your MSSQL databases backup command must be ¿nsrsqlsv -a ¿ instead of "nsrsqlsv" (this is similar to save's -c option for fs backup). If you're running a dedicated database cluster (meaning no other stuff running on the servers) the file system backup of your virtual node may be obsolete as all database files (that are normaly stored on cluster shared disks) are already backed up with NMSQL...

regards.

Hi,

I have added 2 P-Nodes for regular OS backup and added V-Node to backup the shared-drives of the cluster.

And SQL DBA is running the initiating the backups from SQL agent ( I suppose this is a like SQL schedular ) using the following command.
nsrsqlsv -s -C -c -g

So I am not using nsrsqlsv in the command attributes on V-node configuraiton.

So far I see the backups are going well and I see that the D/B backups are updating the CFI of the V-Node that I defined on NW server.

All the 3 clients that I defined on NW server are going to a diffrent pool and the SQL DBA initiated backups are going to different pool. I dont see any thing wrong in this.

If any one has any suggestions or corrections regarding the above it would be great.

Thanks

Hi bkppkb,

you can schedule MSSQL backups as well. You'd need a separate V-node client created with nsrsqlsv command set as backup command attribute. Another suggestion: Perform a recover test to verify that your backup is working and that you're familiar with recover procedures.

regards.