Move all databases (Search Server 2008)

Dieser Inhalt ist vorläufig. Er kann unvollständig sein und unterliegt Änderungen.

This article contains information and steps to move all of the databases associated with Microsoft Search Server 2008 from one database server to another database server within the same farm. You might want to move all of the databases if you are upgrading the hardware or the software on the database server — for example, moving from a 32-bit to a 64-bit version of Microsoft SQL Server 2005.

This article does not provide information about how to migrate or move the Search Server 2008 farm from one group of servers to another group of servers.

This article does not provide information about how to upgrade SQL Server 2005 on the database server. For more information about how to upgrade SQL Server 2005, see the SQL Server 2005 documentation.

You must move the following databases associated with Search Server 2008:

• Databases for Shared Services Provider (SSP)

• Search database for the SSP

• Windows SharePoint Services Help Search database

• Central Administration content database

• Configuration database

Task Requirements

The following are required to perform the procedures for this task:

• You must be logged on to the server that is running the SharePoint Central Administration Web site.

• If you are using Central Administration, you must be a member of the Farm Administrators SharePoint group on the server that is running Central Administration.

• If you are using the Stsadm command-line tool, you must be a member of the Administrators group on the computer that is running Central Administration.

• You must have membership in the following roles in SQL Server 2005:

  • db_backupoperator fixed database role to back up the databases.

  • dbcreator fixed server role on the destination server that is running SQL Server 2005 server or an instance of SQL Server to restore the databases.

• You must coordinate the move procedures with the database administrator (DBA). Steps that require the involvement of the DBA are signified by the prefix “[DBA]”.

Procedure overview

This section summarizes the procedures that you must follow to complete the move process for all the databases associated with Search Server 2008. To see the actual procedure steps, see each procedure following the overview.

In the move process, you will use Search Server 2008 tools and SQL Server 2005 tools. Moving all of the databases from one database server to another database server consists of the following steps:

1. Perform a full backup of the default SSP.

2. Completely stop the farm by stopping the services associated with Search Server 2008 and by stopping Internet Information Services (IIS).

3. [DBA] Back up the following farm databases by using SQL Server 2005 tools:

   • Central Administration content database

   • Configuration database

   • Windows SharePoint Services Help Search database

   Tipp

   The other databases in the farm are backed up and restored with the default SSP.

4. [DBA] Copy or move the backup files to the destination database server.

5. [DBA] Restore the farm databases on the destination database server by using SQL Server 2005 tools.

6. [DBA] Copy to the destination server all of the SQL Server logins, fixed server roles, fixed database roles, and permissions for these databases.

7. Run the Stsadm renameserver operation on the server that is running Central Administration.

8. Restart the server that is running Central Administration to apply the changes and ensure that the services, Web sites, and application pools associated with Search Server 2008 are started.

9. Restore the backed up SSP.

10. Configure the restored SSP to be the default SSP.

11. Remove the old SSP.

12. Associate all of the Web applications to the default SSP that you restored to the farm.

Back up Shared Services Providers

Back up Shared Services Providers by using Central Administration

1. In Central Administration, on the Operations page, in the Backup and Restore section, click Perform a backup.

2. On the Perform a Backup – Step 1 of 2: Select Component to Backup page, select the check box next to the SSP.

3. At the top of page, click Continue to Backup Options.

4. On the Perform a Backup – Step 2 of 2: Select Backup Options page, in the Type of Backup section, select the Full option.

5. In the Backup File Location section, type the Universal Naming Convention (UNC) path of the location where the backup will be stored.

6. Click OK to start the backup.

Stop the farm

Before you can move all of the databases, you must stop the farm to ensure that no changes are made while the databases are moved.

Stop the farm

1. In the Services snap-in on the server that is running Central Administration, stop the following services:

   • Office SharePoint Server Search service

   • Windows SharePoint Services Administration service

   • Windows SharePoint Services Search service

   • Windows SharePoint Services Timer service

   • Windows SharePoint Services Tracing service

   • Windows SharePoint Services VSS Writer service

2. Stop Internet Information Services. You can do this by using the iisreset /stop operation at a command prompt.

Back up databases on the source database server

Back up databases on the source database server

1. Open Microsoft SQL Server Management Studio and connect to the database server.

2. In Object Explorer, expand Databases.

3. Right-click the database that you want to back up, point to Tasks, and then click Back Up.

4. In the Back Up Database dialog box, select the type of backup that you want to perform from the Backup type list. For more information about which backup type to use, see Overview of Recovery Models (https://go.microsoft.com/fwlink/?LinkId=114396&clcid=0x409) in the SQL Server 2005 Books Online.

5. Under Backup component, select the Database option.

6. In the Backup Set section, either use the default name provided or specify a name for the backup set in the Name text box.

7. Specify the expiration date for the backup set. This determines how long, or when, the backup set can be overwritten by any later backups with the same name. By default, the backup set is set to never expire (0 days).

8. In the Destination section, if the correct path of the backup folder is not listed, you can add the path by clicking Add.

9. Click OK to back up the database.

10. Repeat steps 3-9 for each database that you want to move.

Copy or move the backup files to the destination database server

Copy or move the backup files to the destination database server

1. In Windows Explorer, browse to the location of the .bak files for the databases.

2. Select the .bak files for the databases that you want to move, and then either copy or move them to the destination directory.

Restore databases on the destination database server

Restore databases on the destination database server

1. Open Microsoft SQL Server Management Studio and connect to the database server.

2. In Object Explorer, expand the database instance.

3. Right-click the Databases node, and then click Restore Database.

4. In the Restore Database dialog box, under Destination for restore, type the name of the database. You must use the identical name for the database that it had on the source database server.

5. Under Source for restore, select the From device option.

6. In the Specify Backup dialog box, select File from the Backup media list.

7. Click Add, and then browse to the .bak file for the database.

8. Select the .bak file, and then click OK. Click OK again to add the path of the Restore Backup dialog box.

9. Ensure that the backup set is selected in the Select backup sets to restore list.

10. In the Select a page pane, click Options.

11. In the Restore options section, select only Overwrite the existing database. Unless the environment or policies require otherwise, do not select the other options in this section.

12. In the Recovery state section, select the RESTORE WITH RECOVERY option.

    For more information about these recovery options, see Restore Database (Options Page) (https://go.microsoft.com/fwlink/?LinkId=114420&clcid=0x409).

13. Click OK to complete the restore operation.

14. Repeat steps 3-13 for each database that you are moving.

Copy to the destination server all of the SQL Server logins, fixed server roles, fixed database roles, and permissions for these databases

For information about how to copy SQL Server roles and permissions to the destination database server, see Microsoft Help and Support article 246133 How to transfer logins and passwords between instances of SQL Server (https://go.microsoft.com/fwlink/?LinkId=132636&clcid=0x409). For troubleshooting information, see Microsoft Help and Support article 240872 How to resolve permission issues when you move a database between servers that are running SQL Server (https://go.microsoft.com/fwlink/?LinkId=123469&clcid=0x409).

Run the Stsadm renameserver operation

Run the Stsadm renameserver operation

1. On the drive where SharePoint Products and Technologies is installed, change to the following directory: %COMMONPROGRAMFILES%\Microsoft Shared\Web server extensions\12\Bin.

2. Type the following command, and then press ENTER:

   stsadm -o renameserver -oldservername <name of the source database server> -newservername <name of the destination database server>

   For more information, see Renameserver: Stsadm-Vorgang (Office SharePoint Server).

Restart the farm

Restart the farm

1. Restart the server that is running Central Administration.

2. In the Services snap-in, ensure that the following services are started:

   • Office SharePoint Server Search service

   • Windows SharePoint Services Administration service

   • Windows SharePoint Services Search service

   • Windows SharePoint Services Timer service

   • Windows SharePoint Services Tracing service

   • Windows SharePoint Services VSS Writer service (optional)

3. In Internet Information Services (IIS) Manager, ensure that the following Web sites are started:

   • Office Server Web Services

   • All SSP Web sites

   • SharePoint Central Administration v3

Restore a Shared Services Provider

Restore a Shared Services Provider by using Central Administration

1. In Central Administration, on the Operations page, in the Backup and Restore section, click Restore from backup.

2. On the Restore from Backup – Step 1 of 4: Select Backup Location page, type the UNC path of the backup share, and then click OK.

3. On the Restore from Backup – Step 2 of 4: Select Backup to Restore page, select the full backup of the SSP that you want to restore, and then click Continue Restore Process.

4. On the Restore from Backup – Step 3 of 4: Select Component to Restore page, select the check box next to the SSP that you want to restore, and then click Continue Restore Process.

5. On the Restore from Backup – Step 4 of 4: Select Restore Options page, in the Restore Options section, select New configuration.

6. In the New Names section, type the destination database name in the New database server name box.

7. In the New directory name box, type the path of the location on the destination server where the .mdf and .ldf files will be stored. This is the %Program Files%\Microsoft SQL Server\<instance name>\MSSQL\DATA directory.

8. In the New database name text box, type the name of the search database. Use the exact same name as before.

9. Click OK to start the restore.

Configure the restored SSP to be the default SSP

Configure the restored SSP to be the default SSP

1. In Central Administration, on the Application Management page, in the Office SharePoint Server Shared Services section, click Create or configure this farm’s shared services.

2. On the Manage This Farm’s Shared Services page, click Change Default SSP.

3. On the Change Default Shared Services Provider page, select the SSP that you restored from the SSP Name list, and then click OK.

Remove the old SSP from the farm

Remove the old SSP from the farm by using Central Administration

1. In Central Administration, on the Application Management page, in the Office SharePoint Server Shared Services section, click Create or configure this farm’s shared services.

2. Point to the old SSP, click the arrow that appears, and then click Delete.

3. On the Delete Shared Services Provider page, in the Remove SSP section, select the Remove and delete the associated databases option.

4. Click OK to remove the SSP.

Associate the Web application to the SSP

Associate the Web application to the SSP

1. In Central Administration, on the Application Management page, in the Office SharePoint Server Shared Services section, click Create or configure this farm’s shared services.

2. On the Manage This Farm’s Shared Services page, if the Web application is not associated with the SSP, click Change Associations.

3. On the Change Association between Web Applications and SSPs page, select the SSP from the SSP Name list.

4. In the Web applications section, select the Web application that you want to associate to the SSP, and then click OK.

Siehe auch

Konzepte

Maintaining databases (Search Server 2008)
Add, split, and merge content databases (Search Server 2008)
Move content databases (Search Server 2008)