Community
Showing results for 
Search instead for 
Do you mean 
Reply

Trouble migrating database to a new machine

New Member
Posts: 8
Country: USA

Re: Trouble migrating database to a new machine

Mike, thank you for your quick response. Smiley Happy

 

1. We're just using a peer-to-peer workgroup. The new 'server' is running Windows 7 Pro.

2. On both the old and new server, we have a D: drive which houses all of our data (C: is for the OS and application installations). So on the server, it's D:\Server\GMServer, just as it was on the old machine (the folder hierarchies for D: on both machines are absolutely identical). On both machines it's shared out as \\owner-a90b8f167\GMServer and on the client machines I have mapped N: to that UNC path. In lieu of using mapped drives, what is the best way for clients to access the database?

3. Everything under and including the GMServer folder has file/folder permissions set so that Everyone has full Read/Write access. As noted above, the database is not under the Users folder.

4. I will have to perform the migration and get you the error message. It's been awhile since I last attempted it (two months or so), so I'm going from memory.

 

Also please note that when I bring up the new server on the network, the old server is turned off and disconnected from the network. I did that to eliminate as many variables as possible. Before doing this, I also rename the old server to old-a90b8f167 and then after the old server is rebooted and shut down, I rename the new machine owner-a90b8f167 and reboot it. Again, this is to try to recreate as much of the old server's environment as possible. Smiley Happy

Platinum Elite Contributor
Posts: 14,580
Country: Australia

Re: Trouble migrating database to a new machine

1. Did you just copy the files from old PC? Best way is to Backup | Restore - Restore_As
2. The users don't access the database directly and don't need a map.
On server use - Tools | Database Maint | Share
Then users just need access to PAD
Because the PAD file includes the server name and location - opening it on the new server might be finding the old version
Highlighted
Platinum Elite Contributor
Posts: 14,580
Country: Australia

Re: Trouble migrating database to a new machine

If you didn't shut down SQL before the copy, you won't even have a working database on the new server

To move a database see one of these:
http://kb.swiftpage.com/app/answers/detail/a_id/30304
http://kb.swiftpage.com/app/answers/detail/a_id/19818

To share on LAN, see:
http://kb.swiftpage.com/app/answers/detail/a_id/13878

Try all the above ... if still an issue, post exact error