locked
Move sharepoint databases between different SQL versions RRS feed

 > 

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi there,

    Using the steps will work fine for moving from SQL Server 2005 to SQL Server 2008 R2. The script for the logins will also work fine.

    Thanks

    Paul

    Paul Mather | Twitter | http://pwmather.wordpress.com
    • Marked as answer by Gustav Sjoberg Wednesday, November 2, 2011 8:31 AM
    Tuesday, November 1, 2011 8:30 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi ,

    read this maybe will benefit you also

    http://ddkonline.blogspot.com/2010/05/sharepoint-best-practice-using-sql.html

    To greatly simplify migration if you should need to change the port or the server name of your SharePoint database server, you should instead use SQL Server Aliases for your connection from SharePoint to SQL. 

    Regards, Fadi Abdulwahab. http://sqlgoogler.blogspot.com/ Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you
    • Marked as answer by Gustav Sjoberg Wednesday, November 2, 2011 8:31 AM
    Tuesday, November 1, 2011 10:05 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi there,

    Using the steps will work fine for moving from SQL Server 2005 to SQL Server 2008 R2. The script for the logins will also work fine.

    Thanks

    Paul

    Paul Mather | Twitter | http://pwmather.wordpress.com
    • Marked as answer by Gustav Sjoberg Wednesday, November 2, 2011 8:31 AM
    Tuesday, November 1, 2011 8:30 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi ,

    read this maybe will benefit you also

    http://ddkonline.blogspot.com/2010/05/sharepoint-best-practice-using-sql.html

    To greatly simplify migration if you should need to change the port or the server name of your SharePoint database server, you should instead use SQL Server Aliases for your connection from SharePoint to SQL. 

    Regards, Fadi Abdulwahab. http://sqlgoogler.blogspot.com/ Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you
    • Marked as answer by Gustav Sjoberg Wednesday, November 2, 2011 8:31 AM
    Tuesday, November 1, 2011 10:05 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    The TechNet article "Move All Databases (SharePoint 2010)" is your main guide.

    As you correctly noted this article contains the following warning:

    The new database server must be running the same version of Windows Server and Microsoft SQL Server as the existing database server.

    This in NOT true!

    Both from my own experience in migrating SharePoint databases and talks I've had with Microsoft Primary Field Engineering, I can say this method also works when SQL Server versions differ. But only if you upgrade to higher SQL Server versions (i.e. SQL Server 2005 to SQL Server 2008 R2). I was told this scenario is also fully supported by Microsoft.

    Also, don't forget to update the database compatibility level for the migrated databases. This should future-proof your databases and enable advanced SQL Server optimization.
    • Proposed as answer by LZandman Wednesday, May 9, 2012 7:27 AM
    Wednesday, May 9, 2012 7:26 AM