Shifting SharePoint to Database server RRS feed

  • Question

  • Dear Friends

    I have Sharepoint 2007 and SQL server 2008 Running on two separate machines. What i want to do is to Remove SharePoint server and shift all the data to SQL server machine (yes i want to run SharePoint From Database server to remove the actual sharepoint server).

    what i think is

    1. I can install fresh SharePoint to Database server and can give the Existing database when configuring (As SharePoint database is already on Database server)

    2. I can take a backup of sharepoint, install fresh sharepoint on database server and use the new database for sharepoint configuration and then Move things like, site definitions and collections to new server by using the restore.

    3. OR I can just fresh install sharepoint, Take a backup of the databases of the sites i need, create new sites in newly installed sharepoint server, connect the provisos database with new created sites.

    There are some ways i can think of, But i dont want any pain. Any thing you guys can suggust will be good.


    SharePoint 2007 (Administration/Development) | Web developer and .NET DTS Programmer | .NET Framework 2.0/3.5 | SQL Server 2008/2005/2k
    Wednesday, November 24, 2010 11:18 PM


All replies

  • Hi aliusmankhan1,


    Thank you for your post.


    If I understand correctly, what you want to do is to move your SharePoint Server from the original machine to the Database machine, right?  If it is so, I think you can do the following steps:

    1.       To prevent your data loss, I suggest you back up your database first.

    2.       Install SharePoint on the database machine.

    3.       Restore the data and configure SharePoint Server with SQL Server.

    Here are some useful articles, I think these will be helpful and enlightening to you:




    Hope this helps.



    • Marked as answer by aliusman Friday, November 26, 2010 5:37 AM
    Friday, November 26, 2010 1:35 AM
  • Hi aliusmankhan1,


    I have found an useful article, although the version of SharePoint and SQL Server it talks about is different with yours, I think the process is still worth considering:



    Hope this helps.



    Friday, November 26, 2010 3:01 AM
  • Thanks Peng,

    I migrated 2003 to 2007 few months ago and it was done without any issue :) my good luck,

    that is why i have an idea to what to do,

    The article are great, Let me start the migration process and i will let you know how it goes


    SharePoint 2007 (Administration/Development) | Web developer and .NET DTS Programmer | .NET Framework 2.0/3.5 | SQL Server 2008/2005/2k
    Friday, November 26, 2010 5:37 AM