This post is more than 5 years old
1 Rookie
•
124 Posts
0
4144
September 9th, 2014 00:00
NMM SQL DAtbase backup.
HI
I installed the NMM 3.0.1 on our sql server.
The check config was all fine with one warning on a hot fix.
However when i go to add the client to the group. The databases do not show up. The host can resolve the client and visa versa by ip and hostname as well as short name.
So i tried the below commands with successful commands.
Why can i not see the databases in NMC when setting up the client?
C:\Windows\system32>nsrsnap_vss_save -D3vvv -v -?
86745:nsrsnap_vss_save:Version information for C:\Program Files\EMC NetWorker\ns
r\bin\nsrsnap_vss_save.exe:
Original file name: nsrsnap_vss_save.exe
Version: 3.0.1.2.280
Comments: Supporting Microsoft Volume Shadow Copy Service
nsrsnap_vss_save: flag=@
09/09/14 08:44:20.671264 Running in a non-cluster environment
NMM .. current installed NetWorker version for client ALSSQL is 8.1.1. Using _nt
version to check for cluster status.
NMM .. changing backup name ALSSQL to primary name alssql.ialch.co.za for multi
NIC client.
NMM .. started RM session with client.
List of valid saveset entries for APPLICATIONS on client alssql.ialch.co.za ...
Initializing data to display...
NMM .. created RM deposit path C:\Users\IALclad\AppData\Local\Temp\RMDir_9844208
78.
NMM .. RM deposited WMD -- C:\Users\IALclad\AppData\Local\Temp\RMDir_984420878\T
ask Scheduler Writer984423179.xml.
NMM .. RM deposited WMD -- C:\Users\IALclad\AppData\Local\Temp\RMDir_984420878\V
SS Metadata Store Writer984423743.xml.
NMM .. RM deposited WMD -- C:\Users\IALclad\AppData\Local\Temp\RMDir_984420878\P
erformance Counters Writer984424307.xml.
NMM .. RM deposited WMD -- C:\Users\IALclad\AppData\Local\Temp\RMDir_984420878\S
ystem Writer984424868.xml.
NMM .. RM deposited WMD -- C:\Users\IALclad\AppData\Local\Temp\RMDir_984420878\S
qlServerWriter98442687.xml.
NMM .. RM deposited WMD -- C:\Users\IALclad\AppData\Local\Temp\RMDir_984420878\A
SR Writer984426665.xml.
NMM .. RM deposited WMD -- C:\Users\IALclad\AppData\Local\Temp\RMDir_984420878\B
ITS Writer984427234.xml.
NMM .. RM deposited WMD -- C:\Users\IALclad\AppData\Local\Temp\RMDir_984420878\S
hadow Copy Optimization Writer984427791.xml.
NMM .. RM deposited WMD -- C:\Users\IALclad\AppData\Local\Temp\RMDir_984420878\C
OM+ REGDB Writer984428352.xml.
NMM .. RM deposited WMD -- C:\Users\IALclad\AppData\Local\Temp\RMDir_984420878\W
MI Writer984428918.xml.
NMM .. RM deposited WMD -- C:\Users\IALclad\AppData\Local\Temp\RMDir_984420878\R
egistry Writer984429483.xml.
NMM .. RM deposited WMD -- C:\Users\IALclad\AppData\Local\Temp\RMDir_984420878\I
IS Config Writer98443045.xml.
09/09/14 08:44:30.616259 lgto_auth for `nsrexec' succeeded
NMM .. writer ASR Writer is not supported and will not participate in the replic
a. Writers files will be skipped during backup.
09/09/14 08:44:30.643262 lgto_auth for `nsrexec' succeeded
NMM .. writer BITS Writer is not supported and will not participate in the repli
ca. Writers files will be skipped during backup.
09/09/14 08:44:30.669264 lgto_auth for `nsrexec' succeeded
NMM .. Supported writer COM+ REGDB Writer vss type Bootable System State - NMM s
aveset type SYSTEM COMPONENTS:\BootableSystemState.
09/09/14 08:44:30.696267 lgto_auth for `nsrexec' succeeded
NMM .. Supported writer IIS Config Writer vss type System Service - NMM saveset
type SYSTEM COMPONENTS.
09/09/14 08:44:30.720269 lgto_auth for `nsrexec' succeeded
NMM .. writer Performance Counters Writer is not supported and will not particip
ate in the replica. Writers files will be skipped during backup.
09/09/14 08:44:30.748272 lgto_auth for `nsrexec' succeeded
NMM .. Supported writer Registry Writer vss type Bootable System State - NMM sav
eset type SYSTEM COMPONENTS:\BootableSystemState.
09/09/14 08:44:30.775275 lgto_auth for `nsrexec' succeeded
NMM .. writer Shadow Copy Optimization Writer is not supported and will not part
icipate in the replica. Writers files will be skipped during backup.
09/09/14 08:44:30.804278 lgto_auth for `nsrexec' succeeded
NMM .. SQL db string Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19 2012 13:38:57
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service P
ack 1) (Hypervisor)
for ALSSQL.
NMM .. SQL instance ALSSQL -- is type SQL_SQL .. SQL databases. .
NMM .. Supported writer SqlServerWriter vss type User Data - NMM saveset type AP
PLICATIONS.
09/09/14 08:44:31.091306 lgto_auth for `nsrexec' succeeded
NMM .. writer System Writer is not supported and will not participate in the rep
lica. Writers files will be skipped during backup.
09/09/14 08:44:31.118309 lgto_auth for `nsrexec' succeeded
NMM .. writer Task Scheduler Writer is not supported and will not participate in
the replica. Writers files will be skipped during backup.
09/09/14 08:44:31.144312 lgto_auth for `nsrexec' succeeded
NMM .. writer VSS Metadata Store Writer is not supported and will not participat
e in the replica. Writers files will be skipped during backup.
09/09/14 08:44:31.171314 lgto_auth for `nsrexec' succeeded
NMM .. writer WMI Writer is not supported and will not participate in the replic
a. Writers files will be skipped during backup.
09/09/14 08:44:31.196317 Running in a non-cluster environment
09/09/14 08:44:31.202317 Running in a non-cluster environment
09/09/14 08:44:31.208318 Running in a non-cluster environment
09/09/14 08:44:31.214319 Running in a non-cluster environment
09/09/14 08:44:31.219319 Running in a non-cluster environment
09/09/14 08:44:31.225320 Running in a non-cluster environment
09/09/14 08:44:31.230320 Running in a non-cluster environment
09/09/14 08:44:31.235321 Running in a non-cluster environment
09/09/14 08:44:31.241321 Running in a non-cluster environment
09/09/14 08:44:31.246322 Running in a non-cluster environment
09/09/14 08:44:31.252322 Running in a non-cluster environment
09/09/14 08:44:31.257323 Running in a non-cluster environment
09/09/14 08:44:31.263324 Running in a non-cluster environment
09/09/14 08:44:31.268324 Running in a non-cluster environment
09/09/14 08:44:31.273325 Running in a non-cluster environment
09/09/14 08:44:31.280325 Running in a non-cluster environment
09/09/14 08:44:31.285326 Running in a non-cluster environment
09/09/14 08:44:31.291326 Running in a non-cluster environment
09/09/14 08:44:31.296327 Running in a non-cluster environment
09/09/14 08:44:31.302327 Running in a non-cluster environment
09/09/14 08:44:31.308328 Running in a non-cluster environment
09/09/14 08:44:31.313329 Running in a non-cluster environment
09/09/14 08:44:31.319329 Running in a non-cluster environment
09/09/14 08:44:31.325330 Running in a non-cluster environment
09/09/14 08:44:31.331330 Running in a non-cluster environment
09/09/14 08:44:31.337331 Running in a non-cluster environment
09/09/14 08:44:31.342331 Running in a non-cluster environment
09/09/14 08:44:31.348332 Running in a non-cluster environment
09/09/14 08:44:31.354333 Running in a non-cluster environment
09/09/14 08:44:31.360333 Running in a non-cluster environment
09/09/14 08:44:31.366334 Running in a non-cluster environment
09/09/14 08:44:31.371334 Running in a non-cluster environment
09/09/14 08:44:31.377335 Running in a non-cluster environment
09/09/14 08:44:31.382335 Running in a non-cluster environment
09/09/14 08:44:31.387336 Running in a non-cluster environment
09/09/14 08:44:31.393337 Running in a non-cluster environment
09/09/14 08:44:31.399337 Running in a non-cluster environment
09/09/14 08:44:31.404338 Running in a non-cluster environment
09/09/14 08:44:31.410338 Running in a non-cluster environment
09/09/14 08:44:31.415339 Running in a non-cluster environment
09/09/14 08:44:31.421339 Running in a non-cluster environment
09/09/14 08:44:31.426340 Running in a non-cluster environment
09/09/14 08:44:31.432340 Running in a non-cluster environment
09/09/14 08:44:31.438341 Running in a non-cluster environment
09/09/14 08:44:31.443342 Running in a non-cluster environment
09/09/14 08:44:31.449342 Running in a non-cluster environment
09/09/14 08:44:31.455343 Running in a non-cluster environment
09/09/14 08:44:31.460343 Running in a non-cluster environment
09/09/14 08:44:31.467344 Running in a non-cluster environment
09/09/14 08:44:31.472344 Running in a non-cluster environment
09/09/14 08:44:31.479345 Running in a non-cluster environment
09/09/14 08:44:31.484346 Running in a non-cluster environment
09/09/14 08:44:31.490346 Running in a non-cluster environment
09/09/14 08:44:31.495347 Running in a non-cluster environment
09/09/14 08:44:31.501347 Running in a non-cluster environment
09/09/14 08:44:31.507348 Running in a non-cluster environment
09/09/14 08:44:31.512348 Running in a non-cluster environment
09/09/14 08:44:31.518349 Running in a non-cluster environment
09/09/14 08:44:31.524350 Running in a non-cluster environment
09/09/14 08:44:31.529350 Running in a non-cluster environment
09/09/14 08:44:31.535351 Running in a non-cluster environment
09/09/14 08:44:31.541351 Running in a non-cluster environment
09/09/14 08:44:31.546352 Running in a non-cluster environment
09/09/14 08:44:31.552352 Running in a non-cluster environment
09/09/14 08:44:31.567354 Running in a non-cluster environment
09/09/14 08:44:31.573355 Running in a non-cluster environment
09/09/14 08:44:31.578355 Running in a non-cluster environment
09/09/14 08:44:31.584356 Running in a non-cluster environment
09/09/14 08:44:31.589356 Running in a non-cluster environment
09/09/14 08:44:31.595357 Running in a non-cluster environment
09/09/14 08:44:31.601357 Running in a non-cluster environment
09/09/14 08:44:31.607358 Running in a non-cluster environment
09/09/14 08:44:31.613359 Running in a non-cluster environment
09/09/14 08:44:31.619359 Running in a non-cluster environment
09/09/14 08:44:31.624360 Running in a non-cluster environment
09/09/14 08:44:31.630360 Running in a non-cluster environment
09/09/14 08:44:31.636361 Running in a non-cluster environment
09/09/14 08:44:31.642361 Running in a non-cluster environment
09/09/14 08:44:31.648362 Running in a non-cluster environment
09/09/14 08:44:31.653363 Running in a non-cluster environment
09/09/14 08:44:31.659363 Running in a non-cluster environment
"APPLICATIONS:\SqlServerWriter"
"APPLICATIONS:\SqlServerWriter\ALSSQL"
"APPLICATIONS:\SqlServerWriter\ALSSQL\master"
"APPLICATIONS:\SqlServerWriter\ALSSQL\model"
"APPLICATIONS:\SqlServerWriter\ALSSQL\msdb"
"APPLICATIONS:\SqlServerWriter\ALSSQL\ReportServer"
"APPLICATIONS:\SqlServerWriter\ALSSQL\ReportServerTempDB"
"APPLICATIONS:\SqlServerWriter\ALSSQL\CM_IAL"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EnterpriseVaultAudit"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EnterpriseVaultDirectory"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EnterpriseVaultFSAReporting"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EnterpriseVaultMonitoring"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVALSEX1JournalMailboxSt"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVALSEX1PublicFolderStor"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVALSFSDepartmentalStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVALSFSHITDepartmentalSt"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVDefaultMailboxesStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVInactiveFileStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVInactiveMailStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVIncreasedMailboxesStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVITDepartmentStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVPatientDataStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVSeniorManagamentStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVSystemMailboxesStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\ReportServer_EV"
"APPLICATIONS:\SqlServerWriter\ALSSQL\ReportServer_EVTempDB"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVFSAReportingALSFS"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVFSAReportingALSFSH"
"APPLICATIONS:\SqlServerWriter\ALSSQL\coretalk93"
"APPLICATIONS:\SqlServerWriter\ALSSQL\Archive20131126"
"APPLICATIONS:\SqlServerWriter\ALSSQL\IALCH_MICROSOFT_AUDIT"
"APPLICATIONS:\SqlServerWriter\ALSSQL\adaudit"
"APPLICATIONS:\SqlServerWriter\ALSSQL\adauditplus"
102332:nsrsnap_vss_save:Exiting with success.
C:\Windows\system32>
C:\Windows\system32>nsrsnap_vss_save -?
NMM .. changing backup name ALSSQL to primary name alssql.ialch.co.za for multi
NIC client.
List of valid saveset entries for APPLICATIONS on client alssql.ialch.co.za ...
Initializing data to display...
"APPLICATIONS:\SqlServerWriter"
"APPLICATIONS:\SqlServerWriter\ALSSQL"
"APPLICATIONS:\SqlServerWriter\ALSSQL\master"
"APPLICATIONS:\SqlServerWriter\ALSSQL\model"
"APPLICATIONS:\SqlServerWriter\ALSSQL\msdb"
"APPLICATIONS:\SqlServerWriter\ALSSQL\ReportServer"
"APPLICATIONS:\SqlServerWriter\ALSSQL\ReportServerTempDB"
"APPLICATIONS:\SqlServerWriter\ALSSQL\CM_IAL"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EnterpriseVaultAudit"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EnterpriseVaultDirectory"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EnterpriseVaultFSAReporting"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EnterpriseVaultMonitoring"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVALSEX1JournalMailboxSt"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVALSEX1PublicFolderStor"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVALSFSDepartmentalStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVALSFSHITDepartmentalSt"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVDefaultMailboxesStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVInactiveFileStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVInactiveMailStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVIncreasedMailboxesStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVITDepartmentStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVPatientDataStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVSeniorManagamentStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVSystemMailboxesStore"
"APPLICATIONS:\SqlServerWriter\ALSSQL\ReportServer_EV"
"APPLICATIONS:\SqlServerWriter\ALSSQL\ReportServer_EVTempDB"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVFSAReportingALSFS"
"APPLICATIONS:\SqlServerWriter\ALSSQL\EVFSAReportingALSFSH"
"APPLICATIONS:\SqlServerWriter\ALSSQL\coretalk93"
"APPLICATIONS:\SqlServerWriter\ALSSQL\Archive20131126"
"APPLICATIONS:\SqlServerWriter\ALSSQL\IALCH_MICROSOFT_AUDIT"
"APPLICATIONS:\SqlServerWriter\ALSSQL\adaudit"
"APPLICATIONS:\SqlServerWriter\ALSSQL\adauditplus"
102332:nsrsnap_vss_save:Exiting with success.
C:\Windows\system32>
CarlosRojas
1.7K Posts
0
September 9th, 2014 02:00
Hi,
UAC has to be disabled.
Have you checked the permissions on SQL for the NT AUTHORITY\SYSTEM user?.
Check screenshot and make sure it matches the permissions granted, if not present please manually add that user.
Also check the same permissions for the current user you are using (the one highlighted on the error message in nsrsqlra.raw log file).
Thank you,
Carlos
CarlosRojas
1.7K Posts
1
September 9th, 2014 00:00
Hi there,
This is most likely because the NMM SQL RA (Remote Agent) is not registered correctly.
Try this:
On the SQL server open a command prompt and type the following commands:
nmmnmsqlra -i
Then give it another go.
If still doesn't work, then delete the per information on NW server by typing this:
nsradmin -p nsrexec
nsradmin>. type: nsr peer information
delete name: client_name
delete?y
nsradmin>quit
where client_name is the name of the SQL server.
Thank you,
Carlos
ble1
4 Operator
•
14.3K Posts
0
September 9th, 2014 00:00
Did you provide permissions right for service? There is an article about in KB and it applies to SQL 2012. Next, do you plan to use VDI or VSS? If VDI, check access via nsrsqlsv command on the client (though your user might have access so at the end of the day - unless you use user for backup - you still need to add permission to access it to service).
crazyrov
4 Operator
•
1.3K Posts
0
September 9th, 2014 00:00
The backup server is on NetWorker 8.1.x too?
When you say your databases are not visible, do you mean to say when you create a client using the NMC client configuration wizard ? Can you provide a screenshot?
Also, i would just create a normal client instance and put the details manually instead of wasting time on getting the wizard work.
boerbokrib
1 Rookie
•
124 Posts
0
September 9th, 2014 00:00
c:\Program Files\EMC NetWorker\nsr\bin>nsrnmsqlra -i
43708:nsrnmsqlra:Start time: Tue Sep 09 09:29:59 2014
43621:nsrnmsqlra:Computer Name: ALSSQL User Name: ialclad
The remote agent resource with the same values already exists.
CarlosRojas
1.7K Posts
0
September 9th, 2014 00:00
Sorry, I made a mistake on the command.
To register the Remote Agent (which is the agent to be able to use client wizard for NMM) please run this command:
nsrnmsqlra -i
Thank you,
Carlos
boerbokrib
1 Rookie
•
124 Posts
0
September 9th, 2014 00:00
c:\Program Files\EMC NetWorker\nsr\bin>nmmnmsqlra -i
'nmmnmsqlra' is not recognized as an internal or external command,
operable program or batch file.
boerbokrib
1 Rookie
•
124 Posts
0
September 9th, 2014 00:00
Yip 8.1
CarlosRojas
1.7K Posts
0
September 9th, 2014 00:00
Hi there,
Try to unregister it first, then delete the peer information, and register it again.
To unregister run:
nsrnmsqlra -u
then delete peer information as described above.
Then run this command:
vssclupdate
Then register it again running:
nsrnmsqlra -i
Thank you,
Carlos
boerbokrib
1 Rookie
•
124 Posts
0
September 9th, 2014 00:00
SOrry to add it is windows 2008 r2 SQL 2012
CarlosRojas
1.7K Posts
0
September 9th, 2014 01:00
Hi,
For SQL 2012 you need to provide the SQL admin credentials (even during client creation using wizard), did you do that?
Also, do you have UAC enabled? If so please disable it.
Also when running the command please run it as admin.
And check the credentials as well in SQL connections.
Thank you,
Carlos
boerbokrib
1 Rookie
•
124 Posts
0
September 9th, 2014 01:00
Hi
I have noticed this in my nsrsqlra.raw when i add the client.
I cannot see the service the service replication manager exchange interface to change the log on credentials as suggested by crazyrov.
boerbokrib
1 Rookie
•
124 Posts
0
September 9th, 2014 01:00
Hi Carlos
Where do you set the client credentials during wizzard i do not see that.
My networker server properties i have set the user for sql admin and the server as below.
With the user and sql managment studio.
I can connect to sql db.
will have to scheduled reboot for UAC but have done below so far
open secpol.msc on client and:
boerbokrib
1 Rookie
•
124 Posts
0
September 10th, 2014 04:00
rebooted system and still same error. I have now gone bald or think i may be due to me pulling my hair out.
ble1
4 Operator
•
14.3K Posts
0
September 10th, 2014 04:00
Again, have you checked permissions and KB article which discusses this permissions for SQL 2012.