locked
SHAREPOINT 2010 - MOVE DATABASES (question about allias) RRS feed

  • Question

  • Greetings!

    I'm in a phase of moving databases from local sharepoint 2010 SQL2008r2ENTP to a SQL2008R2ENTP on other server. I have some questions about alias.
    BTW I'm using these these two sites for instructions:

    http://www.stuartroberts.net/index.php/2011/09/02/move-sharepoint-database/
    http://technet.microsoft.com/en-us/library/cc512725.aspx


    In the alias sections the instructions are sayin' you must use ORIGINAL SERVER INSTANCE for Alias name. I'm a little bit confused what to put there. If I explain that new server has FQDN (for example SERVER) and I think SQL is without any instances. Why I think there are no instances, because If I look under services.msc on this NEW  SQL server I see service running named as: Sql Server (MSSQLSERVER). Should I then chose alias MSSQLSERVER or can I take some other words (for example SHAREPOINT)?

    Another question is about ports. I see that on current SQL where SHAREPOINT currently stands, it is listening on two ports 1433 and 1434. Does these means I need to create two alias, and each alias listens to it's own port (one for 1433 and one for 1434?). If I need too create two of those, what Alias name should I choose?

    And another thing, after I will complete with this configuration, if I uninstall SQL on SHAREPOINT will thoose alias stay? Will Sharepoint know how to connect to a migrated SQL server?

    With best regards,


    bostjanc


    • Edited by B_C_R Monday, July 2, 2012 12:37 PM
    Monday, July 2, 2012 12:33 PM

Answers

  • Let's say your SharePoint farm is connected to a SQL Server with the following server name: SERVER1. The new database server you've set up is SERVER2.

    In order to move all databases, you create an alias on all SharePoint servers named SERVER1 that points to SERVER2. SharePoint still connects to what it knows as SERVER1 but will be connected by the SQL client tools to SERVER2 without knowing.

    If you use the default instance (MSSQLSERVER) only the server hostname will do, but you can include it if you want to. You will only have to create one alias for the 1433 port. This is also a default, so you don't have to include it.

    If you uninstall SQL Server from your SharePoint servers, the aliases will stay.

    In order to test if an alias works, there is a little trick that I mention on my blog: http://thomasvochten.com/archive/2011/06/sql-aliases-in-the-real-world/

    So if you only use the default instance name and port, you'll have to create the following alias:

    Server Alias: SERVER1
    Server Name: SERVER2
    Port Number: 1433


    SharePoint consultant / platform architect, speaker, accidental DBA & biased allround Microsoft-centric IT Pro @ http://thomasvochten.com

    • Marked as answer by B_C_R Monday, July 2, 2012 12:56 PM
    Monday, July 2, 2012 12:45 PM

All replies

  • Let's say your SharePoint farm is connected to a SQL Server with the following server name: SERVER1. The new database server you've set up is SERVER2.

    In order to move all databases, you create an alias on all SharePoint servers named SERVER1 that points to SERVER2. SharePoint still connects to what it knows as SERVER1 but will be connected by the SQL client tools to SERVER2 without knowing.

    If you use the default instance (MSSQLSERVER) only the server hostname will do, but you can include it if you want to. You will only have to create one alias for the 1433 port. This is also a default, so you don't have to include it.

    If you uninstall SQL Server from your SharePoint servers, the aliases will stay.

    In order to test if an alias works, there is a little trick that I mention on my blog: http://thomasvochten.com/archive/2011/06/sql-aliases-in-the-real-world/

    So if you only use the default instance name and port, you'll have to create the following alias:

    Server Alias: SERVER1
    Server Name: SERVER2
    Port Number: 1433


    SharePoint consultant / platform architect, speaker, accidental DBA & biased allround Microsoft-centric IT Pro @ http://thomasvochten.com

    • Marked as answer by B_C_R Monday, July 2, 2012 12:56 PM
    Monday, July 2, 2012 12:45 PM
  • Thomas, you're da MAN!

    10x


    bostjanc

    Monday, July 2, 2012 12:56 PM