Move all databases to new SQL Server 2005

Question

Hi,

I need to move all my SQL Server 2005 databases to fresh SQL Server 2005 and connect to production sharepoint application server.

Reason:I dont have enough disk space in SQL Server 2005.

Below are my understanding.

1. Prepare new Sql Server 2005 server. 
2. Make note of all database names & it associated database name.
3. Stop all services in central admin.
4. Take all database backup from source server.
5. Detach the databases.
6. move all databases to new server.
7. Create all the database with same names mentioned in step2 in new server. 
8. Attach all the database with the respective backup moved.
9.Redirect the farm to refer new database server
10. Restart all the services in central admin.
11. restart the application server.

Is there any other steps involved in moving database to new new server?

Regards,
Hari
 

 

 

 

Answer 1

You could need some stsadm commands in the middle step to detache ssp databases and other issues and security issues, 

Follow the manual step by step, will help you prepare everything.

"Moving all databases to a different database server or a server with the same name"

http://www.microsoft.com/downloads/details.aspx?FamilyID=65686896-C171-46A8-A95F-54F43AD79952&displaylang=en

Move all databases (Office SharePoint Server 2007)

http://technet.microsoft.com/en-us/library/cc512725.aspx

Hope this help.

---

André Lage Microsoft SharePoint and CRM Consultant
Blog:http://aaclage.blogspot.com
Codeplex:http://spupload.codeplex.com/http://simplecamlsearch.codeplex.com/

Answer 2

Hi Andre,

Thanks for your post.
Downloaded & read the document shared in first article.

I have below doubt.

Why we need to backup & restore SSP ? given from Step 3 -5 in the document?
I am just going for new database server so backup & restore only the database will not work?

Regards,
Hari

Answer 3

Hello,

 

The document that Lage provided are good guidance just meet your need.

 

For your questions about backup & restore SSP databases:

 

In fact, SSP (shared services provider) will only appear at MOSS 2007, it has a particular database which is different from other content databases. So, if you have WSS 3.0, you can ignore this step and only perform backup & restore on content database as you’ve already known.

 

If you are under MOSS 2007 environment, then to backup & restore SSP database is useful. It can recover your settings and configuration about SSP so that no modification will lost. But, if saving the past configuration of SSP is not necessary or you just want to create new SSP, then this step is optional. You can migrate only content databases then create new SSP database in the new server as you like.

 

Regards,

Jerry

---

Xing-Bing Yu

Answer 4

Hi Jerry,

Thanks for your reply.
Pls guide me for below clarification.
I have 2 server , one for application(WindowsServer2003 with MOSS2007) & another for database(WindowsServer2003 with SQL Server 2005) .

Below are list of my databases from my server.

System Databases
DatabaseSnapshots
BOD_Content
Intranet_serarch_sharepointapp
IntranetSPP_content
Mysite_content
sharepoint_AdminContent
sharepoint_config
IntranetDb_content
IntranetMysite_content
IntraneSSP_DB
IntranetSSP_Serach_DB


Now i need to go for new database server bcoz of no free disk space issue, so i need to take backup of all database from my old DB Server & deploy in new server.
And i need to associate the new DB Server in my Applciation server.

Is this enough? do i need to take any special care for SPP?

Regards,
Hari

Answer 5

Hello,

 

According to your condition, the following two links are exactly what you need to check:

 

Moving the SharePoint Databases to a new SQL server instance:

http://blogs.msdn.com/shaden/archive/2007/07/05/moving-the-sharepoint-databases-to-a-new-sql-server-instance.aspx

 

SharePoint 2007 - Move Content and Configuration Databases

http://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-and-configuration-databases/

 

Regards,

Jerry

---

Xing-Bing Yu