Due to the fact that database migration is ineluctable, you need to know how to move SharePoint database to another server. This involves a series of steps that has to be followed strictly lest you fail to move SharePoint database to another server. The procedures employed in this article involves would necessitate you to end the complete farm. Let us have a look at these steps.
1. Prepare the new database server
This is the first step in moving SharePoint database to another server and involves creating a new database server where SharePoint database will be moved to.
2. Record Web applications
This is also an important step as far as moving SharePoint database is concerned. It involves recording Web applications that are associated with SSPs. This information can also be used in reassociating Web applications with SSPs restored.
3. Back up the SSPs
This is equally an important step for it ensures that SSPs will not be lost.
4. Remove the SSPs
This is yet another step as far as how moving SharePoint database to another server is concerned. This is where you will be required to remove SSPs from the farm.
5. Stop the farm
It is advisable that before you move the databases, ensure that you have stopped the farm. This is done mostly to see to it that no changes are made while moving databases.
6. Back up database
Just like backing up the SSPs, backing up databases is also important. Databases which can be backed up include configuration, content, Windows SharePoint services and Central Administration content databases.
It is important to note that moving Single sign-on databases is not possible with the procedures used in this article. You will be required to move SSO database separately.
7. Move or copy database backup files
This is also an important step as far as moving SharePoint database to another server is concerned. This is where you will move backup files to destination server.
8. Restore databases
Not to forget, this is yet another crucial step. This is where you restore databases that you previously backed up.
9. Copy to destination database
This is where you will be required to copy SQL server logins, fixed database roles, databases permission and fixed server roles to the destination database.
10. Redirecting the farm
This is where the firm is redirected to reference new database server. Take note that it is advisable for you to take farm to a new database server by using SQL server connection alias. Ensure that the SQL server connection alias that you will create can be put to use by all the servers.
11. Restart the server
In order to apply the changes and see to it that Web sites, application pools and the services associated with SharePoint are started, you will need to restart the server that runs Central Administration.
12. Restore SSPs
This is actually the last step as far as how to move SharePoint database to another server is concerned. It involves restoring SSPs from the backup.
It conclusion moving databases from one server to another is all about a series of steps that have to be followed strictly. The steps above explains how to move SharePoint database to another server and if you follow them keenly, be sure that moving SharePoint database to another server will be a success.