Attach and restore a read-only content database (Search Server 2010)

Search Server

Applies to: Search Server 2010

Topic Last Modified: 2010-02-18

The information in this section does not apply to Microsoft Search Server 2010 Express. It applies to the full version of Microsoft Search Server 2010 only.

A Microsoft Search Server 2010 farm in which content databases have been set to be read-only can be part of a failure recovery environment that runs against mirrored or log-shipped content databases or part of a highly available maintenance or patching environment that provides user access when another version of the farm is being updated. When you re-attach the read-only databases, they become read-write.

You can only use Windows PowerShell to attach and restore a read-only content database.

To attach and restore a read-only content database by using Windows PowerShell
  1. Verify that you meet the following minimum requirements: See Add-SPShellAdmin.

  2. On the Start menu, click All Programs.

  3. Click SharePoint 2010 Products.

  4. Click SharePoint 2010 Management Shell.

  5. At the Windows PowerShell command prompt, type the following command:

    Mount-SPContentDatabase -Name <DatabaseName> -WebApplication <WebApplicationID> -Verbose


    • <DatabaseName> is the name of the content database that you want to attach.

    • <WebApplicationID> is the identity of the Web application to which you want to associate the content database.

    If you do not use the Verbose parameter, the Command Prompt window displays no message if the operation succeeds. If the operation does not finish successfully, the Command Prompt window displays an error message such as the following:

    Mount-SPContentDatabase : <context-specific error message>. At line: <line> char:<column>. + <cmdlet> <<<< <location of error>

Attaching a content database by using the Mount-SPContentDatabase cmdlet differs from attaching a database in SQL Server by using SQL Server tools. Mount-SPContentDatabase associates the content database with a Web application so that the contents can be read.

For more information, see Mount-SPContentDatabase.

We recommend that you use Windows PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions.