Unsolved
This post is more than 5 years old
1 Rookie
•
83 Posts
0
953
November 3rd, 2010 21:00
Whether NMSQL can restore From one machine to another machine
hi.all:
Whether NMSQL can restore From one machine to another machine.
thanks.
No Events found!


100x
1 Rookie
•
83 Posts
0
November 4th, 2010 01:00
when open the NW user for MSSQL,but another machine could not see the Source machine。
Even if I type the *@* on the source machine。
thanks~
benzino1
2 Intern
•
244 Posts
0
November 4th, 2010 01:00
Try to add source host to hosts file (or make it resolvable any other way) on target and reverse.
If it doesn't help then try to run recover from command line.
benzino1
2 Intern
•
244 Posts
0
November 4th, 2010 01:00
Hi,
There shouldn't be a problem. You have to install NW client and NMSQL module on a target host, define it in NW as a client and add target host to remote access list on the source host. You have to remember about recover order:
First masterdb
Second msdb
Third modeldb
Fourth any other db
If you mark restore all databases NW will recover all components in correct order.
100x
1 Rookie
•
83 Posts
0
November 9th, 2010 23:00
hi,
I've done, But still failed,can not see the other machine, only to see himself.
benzino1
2 Intern
•
244 Posts
0
November 10th, 2010 01:00
Have you backup source machine via Storage Node? If so please add this SN also to hosts file.