Start a Conversation

Unsolved

This post is more than 5 years old

31480

May 3rd, 2013 01:00

SQL 2012 AlwaysON Availability Groups Backup with NMM 2.4

Hi there

Wee need to backup Databases on a SQL 2012 Always On Availability Group.

With NMM 2.4, the Availability Groups from SQL 2012 are supported, but i can 't find a Dokumentation for setup the backup.

We use following Products:

Database Server:SQL2012 Enterprise Edition

OS: Windows 2008R

Hypervisor: VMWARE vSPhere 5.1

I installed the NMM 2.4 Client on the VM's and try to backup the model Database.

Save set: MSSQL:model

We configured the Networker Client with the following command:

nsrsqlsv -A Servername

Theres a error when i do the backup:

43708:(pid 2688):Start time: Fri May 03 09:55:04 2013
43621:(pid 2688):Computer Name: Servername    User Name: SYSTEM
29100:(pid 2688): Invalid SQL virtual server name servername
38563:(pid 2688): Invalid option -A
37758:(pid 2688): Usage: nsrsqlsv [ ] {path}
options: [-CGjqRTvkuHXZ] [-s server] [-N name] [-b pool] [-g group]
         [-S count] [-l level] [-m masquerade] [-U user [-P passwd]]
         [[-A virtual-server] | [-c client]] [-a device interface=data domain] [-f aes] [-w browse] [-y retention]
         [[-A virtual-server] | [-c client]] [-a De-duplication backup=yes] [-a De-duplication node= ] [-a De-duplication client name= ] [-f aes] [-w browse] [-y retention]
path:    d-path | i-path
d-path:  MSSQL: | [MSSQL:]s-path [[MSSQL:]s-path [...]]
i-path:  MSSQL$inst-name: | MSSQL$inst-name:s-path [...]
s-path:  database | database. | database.filegroup |
         database.filegroup. | database.filegroup.file
43709:(pid 2688):Stop time: Fri May 03 09:55:04 2013

srv00801.intmain.introot.bkw-fmb.ch:MSSQL:model: No full backups of this save set were found in the media database; performing a full backup
srv00801.intmain.introot.bkw-fmb.ch:MSSQL:model: retried 1 times.

Is there somewhere a step by step Dokumentation how we can configure SQL2012 Backups ?

142 Posts

March 13th, 2014 02:00

Thanks Hrvjoe,

Disabling the UAC is exactly what was required, now all server-initiated backups are fine.

Regards

tech88kur

February 6th, 2015 23:00

Hi All,

I have also faced the same issue as error code "Cannot run savefs: The requested operation requires elevation." But i tried disabling the UAC but still the issue dint resolve. Some can help me with the resolution.

1.7K Posts

February 7th, 2015 00:00

Try giving user SYSTEM permissions on SQL of dbcreator, public and sysadmin.

Thank you,

Carlos

February 7th, 2015 01:00

As per EMC we need a reboot after UAC setting change, will post you the update after restart.

1.7K Posts

September 14th, 2015 00:00

Hi tech88kur

There is no need to change the login information to the services.

For SQL 2012 you need to add the SQL account information under the Remote User field in the client configuration.

Please make sure you have added that information in the client configuration for a user with the required privileges shown in the documentation.

Also make sure you meet all pre-requisites in terms of permissions. Please refer to the documentation.

Thank you,

Carlos

July 11th, 2016 02:00

Hi Carlos,

I am facing trouble to backup SQL database instance in my environment,

I am getting following trouble as shown below

85897:(pid 9116): Res-list is NULL85555:(pid 9116):Unable to fetch Application Information from resdb database

29085:(pid 9116):Microsoft SQL Server Provider error:

38006:(pid 9116):Named Pipes Provider: Could not open a connection to SQL Server [2]. .

38006:(pid 9116):A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..

38006:(pid 9116):Login timeout expired.

67945:(pid 9116):Cannot login to SQL Server Default Instance.

43709:(pid 9116):Stop time: Mon Jul 11 08:17:38 2016

Could you please guide me to resolve this issue

Thank you

14.3K Posts

July 27th, 2016 04:00

You should open a separate thread for your question (btw, check if SQL is running as it errors out as if it can't find any SQL running - do you run SQL Express or some other thingy or real SQL server?)

No Events found!

Top