Parallels H-Sphere Documentation System Administrator Guide

 

Moving MS SQL Databases Across Servers

 
 

Related Docs:   MS SQL Server Installation

Last modified: 07 Jun 2006

 

WARNING: This documentation covers Parallels H-Sphere versions up to 3.1. For the latest up-to-date Parallels H-Sphere documentation, please proceed to the official Parallels site.

To move the databases from one MS SQL server to another, it is required to:

  1. Install the new MS SQL server, keeping the same path to databases as for the old server. That means, databases on the new server should be located on the same disc and necessarily in the same directory as for the old server.
  2. For example, on the old server data is located on d:\mssql\data\, so the data on the new server should be located in the same directory.
  3. Stop the new MS SQL server.
  4. Copy all MS SQL database files including the "master" database which keeps all logins information and other necessary information.
    All database files should be put into the same directory as for the old server.
  5. Start the new MS SQL server.
  6. Change the MS SQL logical server IP to the new MS SQL server IP in the Control Panel.
  7. All resellers should reconfigure MS SQL server aliases to use the new IP for the MS SQL server.

Related Docs:   MS SQL Server Installation



© Copyright 2017. Parallels Holdings. All rights reserved.