Fulvio Salanitro Sharepoint Attack

Migrare i database di una farm Sharepoint ad un nuovo SQL Server

Può essere necessario per vari motivi spostare i database della nostra farm Sharepoint su un nuovo Database Server.

-Assicuratevi che entrambi i server SQL siano allineati a livello di Service Pack e Updates

-Nel caso dobbiate reinstallare il prodotto Sharepoint fatelo nella stessa lingua della Farm originale

Inoltre prestate attenzione a quanto segue:

Restoration of the configuration database is not supported in SharePoint Server 2007 and in Windows SharePoint Services 3.0
http://support.microsoft.com/kb/948725/en-us

"You cannot just backup and restore (or detach it) the databases. This is because the configuration database of your farm cannot be restored to a new SQL server."

Ecco le due procedure più comuni per completare questa operazione:

Metodo 1

This farm is configured with two separate servers: one web/application server and one sql server..

1. Using the SharePoint Central Admin, make a full backup the whole farm.
2. Start the SharePoint Products and Technologies Configuration Wizard and disconnect the web server from the farm
3. Using the SharePoint Products and Technologies Configuration Wizard define a new farm in the SQL server, that creates a new configuration database
4. (Updated) Using the SharePoint Central Admin restore the full backup in your new farm, running it twice. Select New configuration to be able to change the Database name.
1. Restore first the content database
2. Restore the SSP and its content

Referenze:

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

Restore Windows SharePoint Services 3.0 by using Central Administration
http://technet.microsoft.com/en-us/library/cc288262(TechNet.10).aspx

White paper: Data protection and recovery for Office SharePoint Server
http://technet.microsoft.com/en-us/library/cc262129.aspx

Metodo 2

You can migration migrate the Office SharePoint Server 2007 databases from the source farm to the target farm using SQL Server tools. The Office SharePoint Server 2007 features must be the same, or compatible, between the source farm and the target farm.

Source farm steps

In SQL Server Enterprise Manager, backup all Office SharePoint Server 2007 databases.

Target farm steps

1. Install Office SharePoint Server 2007 on the target farm computer. Do not create a SSP or portal.

2. In SQL Server Enterprise Manager, restore to the target farm computer, all Office SharePoint Server 2007 related databases except the configuration database and the central administrator content database. Use the Restore Databases menu option.

3. In the Office SharePoint Server 2007 central administrator console, create three web applications, one for the SSP, one for the People web application, and one for the portal site. If you have more web applications in the source farm, create the corresponding web applications in the target farm.

4. In the Office SharePoint Server 2007 central administrator console, detach the content database from the newly created web application by doing the following:

1. From the Application Management page click the Content Databases link under the SharePoint Web Application Management section.

2. Change the web application from the drop down list.

3. Select the content database.

4. Select Offline for Database Status and check the remove content database

5. Click OK.

5. Attach the restored site Content database for the newly created web application, people web application and the SSP administrator web application.

1. On the Application Management page click Content Databases under SharePoint Web Application Management.

2. Change the web application from the drop down list

3. Click Add a content database.

4. Enter the SQL Server name and the name of the restored database.

5. Click OK.

6. Restore the SSP

1. On the Application Management page click Create or configure this farm's shared services.

2. Click Restore SSP.

3. Add relative info, SSP web application, people web application, SSP database name, search database name (optional) and click OK.

7. Set the restored SSP as the default SSP for the target farm.

8. Start the search crawl from the Search Setting page in the SSP administrator console.

9. Click OK on the pop up dialog to resume the crawl.

Tratto da:

Using Backup and Restore (Office SharePoint Server 2007):
http://technet2.microsoft.com/Office/ja-JP/library/5a39029f-0939-452b-acd2-44ff87e7ff711041.mspx

Paragrafo: Migrating using SQL Server Tools