New to NW trying to do a POC for SQL DB

I've been using NMSQL so far, but latest NMM has that module in too (due to VDI support).  With that in mind, I don't see much issues (at least not with VDI approach).

Thanks a lot we will be using VDI only.

Since we are doing a SQL2012- cluster servers and ready only server

Like A,B and AB

When we  installed NW client and NMM2.4 on both the cluster do we need to pick  drive which is in cluster group or c drive of both the server are to be taken?

And what about the read only DB server ?

Do we need to have them on same group ?

Simple questions for people in NW community but since i am new to NW i want to make sure.......

Thank you

I haven't use NMM 2.4 yet, but due to adoption of SQL 2012 I will have to move there soon myself - is it possible this sort of configuration topic is not addressed by documentation (didn't check it myself yet).

So how do we configure clusters in NW ? may be that helps me do the same way

Documents does nto specify anything like this .......

Thank you.

In Windows the cluster are handled in a way that you neec client resources for physical nodes and virtual nodes.  Each node has resource associated in cluster management for network and ownership over storage so that's easy. However, SQL 2012 is application cluster and not OS cluster (unless you have something different) so things might be a bit different (think of Exchange 2012 or Oracle RAC).

I installed and tryed to take a filesystem backup and failed these sre the following configurations i made for group and client

Client properties-name

backuptype-Filesystem

checpoint enabled

checkpoint granularity-directory

doirective-sql directive

client direct-yes

group filesystems

pool-Datadomain

backup renamed directories-yes

apps &modules- dint give user name passowrd

backup command-nsrsnap_vss_save.exe

application informat-

NSR_SNAP_TYPE=VSS

NSR_VSS_FORCE_SYSTEM_PROVIDER=yes

datadomain=yes

storagenodes-nsrserverhost

Please let me know if i make anything wrong?

Thank you

If you are using NMM, Pool entry in client configuration has to be empty.

In Media - Media Pools - Name_of_Pool - Data Source box, check desired backup group, and try again.

Hi Zlatko

I tried  the options you specified and recommended and i am still geting these errors in File system backups

C:\: NSRSNAPCK::success

C:\: Backup of failed

1 E:\SS2K12$SQL12\DBDATA E:\SS2K12$SQL12\DBTLOG E:\ D:\SS2K12$SQL12\DBTLOG2 D:\SS2K12$SQL12\DBTLOG1 D:\SS2K12$SQL12\DBDATA1 D:\SS2K12$SQL12\DBDATA D:\SS2K12$SQL12\DBTLOG D:\ C:\

[nsrsnap.c 2060] Calling snap_wait..

[nsrsnap.c 2081] Calling parse_fs_logs_and_prefix..

86745:nsrsnap_vss_save:Version information for C:\Program Files\EMC NetWorker\nsr\bin\nsrsnap_vss_save.exe:

    Original file name: nsrsnap_vss_save.exe

    Version: 2.4.1.92

    Comments: NetWorker Module for Microsoft Applications (x64)

50423:nsrsnap_vss_save:nsrsnap_vss_save: Unknown Application Information parameter: DIRECT_ACCESS, may not be supported

50411:nsrsnap_vss_save:nsrsnap_vss_save: Data mover host name not specified. Assuming local host:xxx.com

67770:nsrsnap_vss_save:NMM .. Snapshot rollover policy. Group: "Test-OS" Snapshot Policy: "Test-OS" Rollover: "All".

88430:nsrsnap_vss_save: Checking NetWorker Privileges: User  does not have "Operate NetWorker","Backup Local Data" and "Recover Local Data" privileges on xxxx.com

63322:nsrsnap_vss_save:NMM has detected that client does not have enough permissions.

63335:nsrsnap_vss_save:NMM backup failed to complete successfully.

Internal error.

68151 1361667007 2 0 0 8324 6040 0 xxx.com nsrsnap_vss_save NSR warning 39 nsrsnap_vss_save: Exiting with failure. 0

E:\: NSRSNAPCK::success

E:\: Backup of failed

The group and client properties are as follows-

Group-

Snapshots-enabled

snapshot policy-Filesystems

snapshot pool-datadomain

Advanced tab-nothing changed from defaults in options i have manual restart

Client properties-name

backuptype-Filesystem

checpoint disabled

checkpoint granularity-directory

doirective-sql directive

client direct-disabled

group filesystems

pool-Empty

backup renamed directories-yes

apps &modules- dint give user name passowrd

backup command-nsrsnap_vss_save.exe

application informat-

NSR_SNAP_TYPE=VSS

NSR_VSS_FORCE_SYSTEM_PROVIDER=yes

datadomain=yes

storagenodes-nsrserverhost

Please let me know what i have to do to make this work.

I am sorry Carlos. marking the rest of them as answered.