locked
Migrate DB to new SQL 2008 R2 server. RRS feed

  • Question

  • I need to migrate a SQL 2000 server that contains a SharePoint database to a SQL 2008 R2 server

    The SharePoint is actually a WSS 3.0, at this moment we do not want to move\migrate\touch the SharePoint server itself just the DB.

    I have no clue how to start this project. Perhaps just backup the DB and Restore it in the 2008 server? Any help will be very much appreciated. Thanks!


    Simon
    Thursday, October 27, 2011 6:44 PM

Answers

  • Hi,

    If you want to move all the databases in a WSS 3.0 farm to a new database server that has a different name. The new database server must use the same version of Windows Server and SQL Server as the old database server. To move the databases to an identically named or upgraded server, use the Move all databases to an upgraded database server procedure.

    After moving all databases to the new database server, you need to check some service accounts'database permissions. if some necessary permissions are lost, you need to add them again from sql server root node > security > Logins

    Seven Ma

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tnmff@microsoft.com 

     

    • Marked as answer by Wayne Fan Wednesday, November 9, 2011 1:37 AM
    Friday, October 28, 2011 7:43 AM