the SQL Database from one server to another: SharePoint 2007
1. Open up the Central Administration and select the Operations tab.
2. Select the Perform a backup from the Backup and Restore section
3. Select the checkbox next to Farm.
4. After the checkbox is selected, click on the Continue to Backup Options tab.
5. On the Start Backup – Step 2 of 2 page, select Full under the Type of Backup option
6. Specify the Backup location in the text box. You must use a correct share name such as \\MyServerName\c$\backup\SharePoint. Also, the folders need to be created before you begin the backup
7. During the backup, the Backup and Status page will refresh and show the latest stats on the backup operation.
8. When the backup is completed, the status will show the job complete as well as other details
After the backup is completed, you need to remove the servers from the farm.
1. Logon to the server where SharePoint 7 is installed and launch the SharePoint Products and Technologies Configuration Wizard. When the Wizard has launched, click the Next button
2. You will get a warning about services that have to be started or reset. Click Yes to continue
3. Select the Disconnect from this server farm option and click on the Next button
4. A warning message will popup, explaining what the implication is when performing this action. Select the Yes button to continue.
5. When the Wizard has completed the task, click Finish to exit the Wizard
The next phase is to create a new database on the new database server
1. Launch the SharePoint Products and Technologies Configuration Wizard and click Next
2. You will get a warning about services that have to be started or reset. Click Yes to continue
3. Select the option No, I want to create a new server farm on the Connect to a server farm
4. Enter the name of the database server. You can accept the default name of the database name or you can rename it. I named mine MOSS_Config. You also need to specify the Username and Password of an account that will always connect to the database. When you have entered all the required information, click the Next button to continue
5. Specify the port number you want to use to access the Central Administration page inside SharePoint. If you do not want to specify a port number, you can use the port that the Wizard generated. Next, select the type of an authentication provider you want to use. I use NTLM as this SharePoint server is located on the company intranet and is not exposed to the public
6. The next screen will give an overview of the database configuration. Click the Next button to continue
7. When the database configuration is complete, click the Finish button to exit the Wizard
The next phase is to restore the data from the backup that was performed earlier
1. Click on the Operations tab on the Central Administration page. Find the Restore from backup link under the Backup and Restore section, and then click on the link.
2. Enter the path where the backup was created. Then click the OK button
3. A summary page will appear with any backup jobs that have been completed. Select the backup you made from the earlier step, then click on the Continue Restore Process button.
4. Select the component to restore. When restoring the entire farm, select the checkbox next to the Farm option. Then select the Continue Restore Process button
5. On the Step 4 of 4 page, click Same configuration under the Restore Options. A warning message will popup. Click OK to continue.
6. Complete the Login name and Password text boxes. The rest of the text boxes should be pre-filled with the data from the backup and should not have to be changed. Click the OK button to continue
7. You can monitor the status of the restore by keeping the screen up. The page will refresh itself every 15-30 seconds.
8. When the restore is completed, a summary is displayed. During my restore of my development install, I did have three areas that failed during the restore. However, as this is a development machine, I have done a lot of modifications, creation and deletion of web applications and site collections. The main project that I have been working on did restore just fine and that was my main concern as it was the cleanest and most current project I am working on.
9. You need to make sure the Office SharePoint Server Search and the Windows SharePoint Services Search are started. Mine were not started after the restore and I went in and started the services
10. When I attempted to start the services, I had to enter the Username and Password for the Service Account and the Content Access Account.
11. That’s the end of moving SharePoint to another database server
Reference:
1. http://www.precisionnetworks.com/post/Moving-the-SQL-Database-from-one-server-to-another-SharePoint-2007.aspx
2. http://techacid.spaces.live.com/blog/cns!6D62FC28E76BE4B!230.entry
