Unsolved
This post is more than 5 years old
7 Posts
0
1650
MSSQL: saveset is not backing up all the database
Hi,
the MSSQL client is not backing up all the online database what we mentioned in the script file (backup command in client defination)
what could be the reason,
Data base missing - Navision Monitor
MSSQL:KD-PROD
MSSQL:master
MSSQL:model
MSSQL:msdb
MSSQL:PRD-KD-OLA
need help on this.
Panwar
79 Posts
0
March 21st, 2012 06:00
Hi
Kindly provide NMSQL module version and backup command mentioned in the Client properties.
Panwar
djnair
1 Message
0
March 22nd, 2012 06:00
NMSQL Version - 5.2.2.23
Command - nsrsqlsv.exe -I C:\drift\DBLogfiles\Sql_All.txt
CarlosRojas
1.7K Posts
0
March 24th, 2012 22:00
Raja999 and djnair, are you the same person?
If not Raja999 please let us know the NMSQL module version and build as well as the saveset you are using.
Also please render nsrsqlsv.raw and paste out here the output.
djnair, can you please let us know the content of Sql_All.txt?
Also please render the nsrsqlsv.raw and paste here the output.
Thank you.
Carlos.
Jejje1
13 Posts
0
March 27th, 2012 05:00
The issue in this case is that the include file doesnt support a database with a name with a " " space in the name.
MSSQL:Navision Monitor
this needs to be specified as
"MSSQL:Navision Monitor"
in order to be included in the backups.
maybe EMC can work on trying to give an error message for this behaviour. as the NMSQL module is silent regaring these "incorrect" entries in the include file. it just backos all the "other" databases