Loading

MOSS Moving Database Server

There would appear to be many different types of methods to move database servers for the MOSS Databases. the steps below have worked well for me:

  • Build new SQL Server (4xCPU and 4GB RAM) or use exsisting
  • Enable new SQL Server for TCP/IP and listen to all ports
    • Open SQL Server Configuration Manager

SQLListen 

  • Create security login accounts as on old server on new server (Farm and web app accounts)
    • Either make a note of each user and permissions under Security-Logins
    • Or Script each Security-Logins relating to SharePoint

SQLScriptLogon 

  • Set all MOSS Databases to read-only on existing server.
    • SharePoint_Config.. (should have one)
    • Content.. (should have one or more)
    • AdminContent..(should have one or more)
  • Backup all MOSS Databases on existing server.
    • SharePoint_Config.. (should have one)
    • Content.. (should have one or more)
    • AdminContent..(should have one or more)
  • Restore all MOSS Databases to new server
    • SharePoint_Config.. (should have one)
    • Content.. (should have one or more)
    • AdminContent..(should have one or more)
  • On all MOSS Servers (WFE, QUERY, INDEX) Start the SQL Server Native Client Network Utility (%SYSTEM%cliconfg.exe), then run through the following:
  1. On the General tab, verify that TCP/IP is enabled.
  2. On the Alias tab, click Add.
  3. Repeat steps a through f on all servers that connect to SQL Server.
  4. The Add Network Library Configuration dialog box appears.
  5. In the Server alias box, enter the name of the existingold instance of SQL Server.
  6. In the Network libraries area, click TCP/IP.
  7. In the Connection parameters area, in the Server name box, enter the new server name and instance to associate with the alias, and then click OK.

MOSSMOVEDBSERVER

UPDATE 27-Oct-2009: Added some more pictures

0 thoughts on “MOSS Moving Database Server

Leave a Reply

Your email address will not be published. Required fields are marked *