Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Seperating the Database and Application Servers

  Asked By: Ralph    Date: Dec 04    Category: MOSS    Views: 801

We are using a single server (e.g. Server1) to host our MOSS 2007 application
and the site collections that we create under the web applications use the
machine name as their Urls (e.g. http://Server1, http://Server1:7000).

As the databases grow and our number of users increase, we decided to seperate
the database server and application server. SQL server will remain on the same
server and application server will be moved to a new server. However we want the
newly created application server's name to remain the same with the old one
(Server1), and rename the old server (hosting the databases) (e.g. Server-SQL).

In order to do so:

Disconnect MOSS 2007 application from configuration database.
Rename the server's computer name (Server1) to Server-SQL from System Settings.
Restart the server.
Open the SQL Server Management Studio and run following query:

sp_dropserver Server1
GO
sp_addserver Server-SQL, local
GO

Rename the new server to Server1. Restart the server.
Copy the necessary DLLS, 12 Hive and other files to the new server.
Connect to the configuration database on the old server (Server-SQL)

Is there anything that I miss above?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Seperating the Database and Application Servers Or get search suggestion and latest updates.