H-Sphere Documentation Sysadmin Guide

 

Moving MS SQL

 

Related Docs:   MS SQL Server Installation

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





User comments
No comments for this page.
Add comment


Home   Products   Services   Partners   Support   News   Contact   Forum
© 2020 psoft.net
All rights reserved.