Moving Site collection from 1 content database of Sql Server 1 to another database of Sql Server 2 RRS feed

  • Question

  • HI,

    I am trying to figure out a way to move our site collection from DB1 database of Sql server 1 to DB2 database of Sql Server 2. I have tried Move-SpSite but that only move the database from 1 database to another database within same Sql server but i want on different sql server. If you guys have done, please let me know. it will be very helpful to move out read only SC data out of active Sql Servers. Here is the error message i am getting using Move-SpSite in powershell

    Are you sure you want to perform this action?
    Performing operation "Move-SPSite" on Target "http://SPserver/sites/test".
    [Y] Yes  [A] Yes to All  [N] No  [L] No to All  [S] Suspend  [?] Help
    (default is "Y"):Y
    Move-SPSite : Invalid object name 'DBTest.dbo.AllSites'.
    At line:1 char:12
    + Move-SPSite <<<<  "http://SPserver/sites/test" -DestinationDatabase "DBT
        + CategoryInfo          : InvalidData: (Microsoft.Share...PCmdletMoveSite:
       SPCmdletMoveSite) [Move-SPSite], SPCmdletException
        + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletMoveSite


    BJ Singh

    Thursday, July 12, 2012 3:11 PM

All replies