Apex Customer Portal Apex Customer Portal
Forums Pictures Articles Downloads
Advanced purchasing for Electrical, Plumbing, and HVAC contractors
Register Active Topics Members Search Bookmarks FAQ
Save Password Forgot your password?
 All Forums
 Microsoft SQL Server
 How To: Move the Apex database via Enterprise Mgr
 Printer Friendly Version  
Author Previous Topic Topic Previous Topic  

131 Posts
Posted - December 27 2004 :  01:13:00 AM  Show Profile Send a private message to admin
How do I move the Apex Database to a new server?

Since I don't know your actual server names I will refer to them as "New Server" and "Old Server". You will want to ensure that no one uses Apex during this entire procedure. It is also a good idea to make a backup of the Apex database before attempting to move it.

Here is a procedure to move the database:

  1. Install SQL Server on the new server. If you are using SQL Server 2000, you should also install SQL Server 2000 service pack 3.

  2. On the new server run the Enterprise Manager and add SQL Server registrations to both the new server and the old server. This gives you access from one console to both the SQL Server on the new machine and to the MSDE program (or SQL Server) running on Old Server.

  3. Configure the new server to use "SQL Server and Windows" (SQL Server Standard or "Mixed Mode") security. This is done by right clicking on the server in the Enterprise Manager, selecting Properties, and then selecting the Security tab. Select "SQL Server and Windows" security.

  4. Using the Enterprise Manager select Old server, Security/Logins and delete the ApexProg login. This will also remove the ApexProg user account in the Old Server Apex database.

  5. Using the Enterprise Manager select Old server, right click on the Apex database, select All Tasks, and detach the database.

  6. Using Windows Explorer (or equivalent) copy the Apex.mdf (or Apex_Data.mdf) and Apex.ldf (or Apex_log.ldf) files on Old server to where you want them to be located on the new server. The Apex database file names may change depending on how and when your database was installed, but is usually one of these two variations for the .mdf and .ldf files.

  7. Using the Enterprise Manager select the new server, right click on the Databases item and select "All Tasks/Attach Database". Attach the .mdf database file that you moved in step 6. This will put entries under the file locations for both the .mdf and the .ldf files. Make sure that they make sense, or edit them if needed. Make sure that the "sa" account is the owner of the attached database.

  8. Using the Enterprise Manager select the new server, refresh the list of databases, right click on the Apex database, and select properties. On the Options tab pick a recovery model. If you are not familiar with recovery models and doing transaction log backups, pick the "Simple" recovery model.

  9. Using the Enterprise Manager select the new server, select Security/Logins, right click and add a new login. The login name is ApexProg, with a password of "eieio". The default database should be Apex. On the Database tab check the box next to Apex and then select the Public and db_Owner roles.

  10. Each workstation then needs to be redirected to the new server. Run the BDE Administrator on each workstation and adjust the ApexCS database alias accordingly.

For more information, Microsoft has a good knowledge base article here

Jump To:

Set as your default homepage Add favorite Privacy   2017 Vulcan Software LLC All Rights Reserved.   Go To Top Of Page