Move content databases (Search Server 2008)

  • Artikel

You can move content databases between Microsoft SQL Server 2005 instances, from one server running Microsoft Search Server 2008 to any other server running Search Server 2008, from one Web application to another, or from Windows Internal Database to a SQL Server 2005 instance. You can also move one or all content databases for any Web application to another Web application.

Tipp

Windows Internal Database uses SQL Server technology as a relational data store for Windows roles and features only, such as Windows SharePoint Services, Active Directory Rights Management Services, UDDI Services, Windows Server Update Services, and Windows System Resources Manager.

You might move content databases as part of an upgrade or migration process, as part of a backup and recovery process, or as part of the process of moving your sites from a development environment to a production environment.

Wichtig

This article covers moving only content databases and does not provide information for moving other databases that are associated with Search Server 2008.

You can perform this task by using either the SharePoint Central Administration Web site or by using the Stsadm command-line tool.

Wichtig

Wenn Sie eine Inhaltsdatenbank trennen und erneut anfügen, sollten Sie sich darauf einstellen, dass beim nächsten Crawling des Inhalts der Inhaltsdatenbank ein vollständiger Crawl ausgeführt wird, auch wenn ein inkrementeller Crawl angefordert wurde. Vollständige Crawls können erheblich mehr Zeit in Anspruch nehmen als inkrementelle Crawls, da bei vollständigen Crawls ein erneutes Crawling des vom Crawler festgestellten Inhalts stattfindet. Dies findet unabhängig davon statt, ob im Vorfeld bereits ein Crawling des Inhalts stattgefunden hat.

If you are running the Infrastrukturaktualisierung für Microsoft Office Server, the identifier (ID) of each content database is retained when you restore or reattach the database by using built-in tools. Default change log retention behavior when using built-in tools is as follows:

  • The change logs for all databases are retained when you restore a farm.

  • The change log for a content database is retained when you reattach the database.

  • The change log for a content database is NOT retained when you restore just the content database.

When a database ID and change log are retained, Search continues crawling based on the regular schedule defined by crawl rules. When a change log is not retained, Search performs a full crawl during the next scheduled crawl.

Task Requirements

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

  • You must be a member of the Administrators group on the source server computer and the destination server computer.

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

    • The dbowner fixed database role for the database on the source server running SQL Server 2005 or SQL Server instance, to detach the database.

    • If you are moving the databases from one farm to another farm, you must make the database access account a member of the Administrators group on the database server during the restore process. This is required for the account to replicate the security setting for the databases. This access level can be removed after the restore process is complete.

    • The dbcreator fixed server role on the destination server running SQL Server 2005 server or SQL Server instance, to attach the database.

To move content databases, you can perform the procedure that corresponds to your environment:

Siehe auch

Konzepte

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