Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Restore database PM6 to other computers

4 replies [Last post]
Mon, 2010-04-05 10:29
Tommy Nug
User offline. Last seen 6 years 37 weeks ago. Offline
Joined: 16 Nov 2007
Posts: 44
Groups: Civil Engineering
Hello ALL,

I am not sure if i can find how to restore a database from one computer to the others or not:

I follow back-up steps on my computer:
1. Open SQL Server Management Studio Express
2. Name: sa, pss: Prima123Vera
3. Select Database/pmdb$primavera, right click to backup (type: full, expire after 0 days)
4. Save a backup file with extension *.bak

The problem is, i can use this file to restore on this computer but can not restore that file in another computer. Why cant I?
Top

Replies

Mon, 2010-04-05 18:11
#1
Rodel Marasigan
User offline. Last seen 23 weeks 6 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
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)
Top
Mon, 2010-04-05 12:20
#2
Tommy Nug
User offline. Last seen 6 years 37 weeks ago. Offline
Joined: 16 Nov 2007
Posts: 44
Groups: Civil Engineering
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?
Top
Mon, 2010-04-05 12:20
#3
Tommy Nug
User offline. Last seen 6 years 37 weeks ago. Offline
Joined: 16 Nov 2007
Posts: 44
Groups: Civil Engineering
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?
Top
Mon, 2010-04-05 10:55
#4
Rodel Marasigan
User offline. Last seen 23 weeks 6 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
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.
Top