Move MOSS 2007 configuration and content databases from SQL2003 to SQL2008R2 server RRS feed

  • Question

  • I have two (2) part question;

    Here is our set up:

    1. We are currently running SharePoint 2007 on SQL2003. We have to move from SQL 2003 to SQL 2008R2. Can someone help with the process?

    2. We have to move the SharePoint 2007 applications to another server. Can someone help?

    At the current time we are staying with SharePoint 2007 for our Intranet. 

    Friday, July 13, 2012 7:24 PM

All replies

  • SQL 2003 ??? I don't think Microsoft has any such version of SQL Server.  Did you mean SQL Server 2005?

    Thanks & Regards,
    Kamlesh | Blog | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.

    Saturday, July 14, 2012 8:36 AM
  • You are correct SQL 2005, as I was writting I have a these projects going on.
    Monday, July 16, 2012 9:06 PM
  • Hi,

    - Back up or copy the databases and then migrate the data to the new SQL Server 2008. You have option in sql to get back and restore to other server.

    Please follow the same thread


    Hope it could help. Let us know if any issue

    Cheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"

    Tuesday, July 17, 2012 11:58 AM