Restore database PM6 to other computers

T
Tommy Nug 👤 Member for 18 years 7 months
R
Rodel Marasigan 👤 Member for 19 years 7 months

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)

T
Tommy Nug 👤 Member for 18 years 7 months

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?

T
Tommy Nug 👤 Member for 18 years 7 months

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?

R
Rodel Marasigan 👤 Member for 19 years 7 months

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.

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