Community
Showing results for 
Search instead for 
Do you mean 
Reply

Move shared database to new server

New Member
Posts: 2
Country: United States

Move shared database to new server

I am in the process of moving the act database from one server to another and I have run into a snag.  I read the postings for moving databases which says to run a backup and then restore to the new server.  I tried this and received an error that the application could not read a .bak file, which is a SQL backup file.  I have tried stopping the SQL instance and copying the files to a new location, this almost worked, however, the database still has a link to the old SQL database.  How do I move the database from one server to the other?

 

Thanks

Copper Super Contributor
Posts: 206
Country: USA

Re: Move shared database to new server

On the new server restore and share the .bak file using the "restore as" option. Having done that you should be able to point (browse)to the new location from any client machine.
Brad Marquardt
realtimeACT, Inc
Colorado, USA
New Member
Posts: 2
Country: United States

Re: Move shared database to new server

I figured out the problem was that the system did not have rights to create the .bak file on the server.  My other question is I have a license code from the initial installation of Act.  Can I re-use this code to install the software on the new server?