Restore database PM6 to other computers
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Tommy,
It recognise the server name and not the user because users can be SQL authentication not just window authentication. For SQL authentication you can use the default which is privuser (usersname and password)
Thanks Rodel,
Can we change the user name of destination sever? I believe the reason we can not restore is because it does not match with the original name of back up file. Am i correct?
Thanks Rodel,
Can we change the user name of destination sever? I believe the reason we can not restore is because it does not match with the original name of back up file. Am i correct?
Tommy,
The back-up file recognized the original server so you cannot restore it to other computer. The best way is back-up to xer. You can use one xer for all by selecting the highest level of enterprise.
Another way is copy across all data from MSSQL folder. You need to copy the original to the safe location incase it did not work on your copy from other computer so you can copy it back.