Unsolved
This post is more than 5 years old
14 Posts
0
31480
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 ?
tech88kur
142 Posts
0
March 13th, 2014 02:00
Thanks Hrvjoe,
Disabling the UAC is exactly what was required, now all server-initiated backups are fine.
Regards
tech88kur
JitheshJayan
2 Posts
0
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.
CarlosRojas
1.7K Posts
0
February 7th, 2015 00:00
Try giving user SYSTEM permissions on SQL of dbcreator, public and sysadmin.
Thank you,
Carlos
JitheshJayan
2 Posts
0
February 7th, 2015 01:00
As per EMC we need a reboot after UAC setting change, will post you the update after restart.
CarlosRojas
1.7K Posts
0
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
sandeep00000
6 Posts
0
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
ble1
14.3K Posts
0
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?)