{"id":278,"date":"2013-04-19T06:26:16","date_gmt":"2013-04-19T05:26:16","guid":{"rendered":"https:\/\/www.em-soft.si\/myblog\/elvis\/?p=278"},"modified":"2013-04-19T06:26:16","modified_gmt":"2013-04-19T05:26:16","slug":"migrate-from-sbs-2008-or-2011-part-3","status":"publish","type":"post","link":"https:\/\/em-soft.si\/myblog\/elvis\/?p=278","title":{"rendered":"Migrate from SBS 2008 or 2011 (Part 3)"},"content":{"rendered":"

Migrate SharePoint Data (Optional)<\/strong><\/span><\/p>\n

This step is an optional. If you are using SBS SharePoint, you might wish to migrate it. SBS deployments that don\u2019t use this component, can skip this step.<\/span>
\nYou will be able to attach a content database to a destination server only if the version of SBS SharePoint is SP2 or later and the content database is prepared for migration.<\/span>
\nTo check the version of SharePoint, follow this steps:<\/span><\/p>\n

    \n
  1. In Start menu go to Administrative tools <\/strong>and lunch SharePoint 3.0 Central Administration<\/strong>.<\/span><\/li>\n
  2. Click on Operations<\/strong> in top menu.<\/span><\/li>\n
  3. Click on Servers in farm <\/strong>on the left pane.<\/span><\/li>\n
  4. On the right pane you can see the SharePoint version of Small Business Server. If it is SP2, the number must be at least 12.0.0.6421<\/strong>. For migration proposes it will be acceptable any version greatest of this one.<\/span><\/li>\n<\/ol>\n

    Before you begin with migration, it is necessary to verify upgrade readiness on SBS Server. Follow this steps:<\/span><\/p>\n

      \n
    1. Open Command prompt <\/strong>as Administrator.<\/span><\/li>\n
    2. Navigate to folder C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12BIN<\/span>, where C:<\/span> is the name of the system drive.<\/span><\/li>\n
    3. Run the Command STSADM.EXE -o preupgradecheck<\/strong>.<\/span><\/li>\n
    4. Review the report located in C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12LOGS <\/span>and search for errors.<\/span><\/li>\n
    5. If there are no errors, the site is ready to upgrade, otherwise correct all the errors.<\/span><\/li>\n<\/ol>\n

      On the new server install SharePoint Foundation following this steps:<\/span><\/p>\n

      \u00a0<\/span><\/p>\n

        \n
      1. Download the package from http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=5970<\/a>.<\/span><\/li>\n
      2. \u00a0<\/span>Run the downloaded package and click Install software prerequisites<\/strong>.<\/span><\/li>\n
      3. On SharePoint preparation tool click Next<\/strong>.<\/span><\/li>\n
      4. Accept EULA and click Next<\/strong>.<\/span><\/li>\n
      5. It will take few minutes to complete all installation tasks. After this click Finish<\/strong>.<\/span><\/li>\n
      6. Rerun the downloaded package and select Install SharePoint Foundation<\/strong>.<\/span><\/li>\n
      7. Accept EULA and click Continue<\/strong>.<\/span><\/li>\n
      8. On Choice the installation you want<\/em> select Server Farm<\/strong>.<\/span><\/li>\n
      9. It will take few minutes to complete the installation.<\/span><\/li>\n
      10. On the Installation complete<\/em> screen, leave the checkbox in Run configuration wizard <\/strong>and click Close<\/strong>.<\/span><\/li>\n
      11. Complete the Configuration Wizard specifying your configuration.<\/span><\/li>\n
      12. Click on Start, All Programs, SharePoint 2010 Products and lunch SharePoint 2010 Central Administration<\/strong>.<\/span><\/li>\n
      13. In the Web Applications section click Manage Web Application<\/strong>.<\/span><\/li>\n
      14. In the Ribbon click New<\/strong>.<\/span><\/li>\n
      15. In Create Web Application <\/strong>window change those values:<\/span>\n
          \n
        1. In the IIS Web Site <\/strong>section:<\/span>\n
            \n
          1. Select Create a new IIS Web Site<\/strong>.<\/span><\/li>\n
          2. In the Host Header <\/strong>box type your desired host name.<\/span><\/li>\n<\/ol>\n<\/li>\n
          3. In the Application Pool <\/strong>section:<\/span>\n
              \n
            1. Select Create new Application pool<\/strong>.<\/span><\/li>\n
            2. Select Configurable<\/strong>.<\/span><\/li>\n
            3. Type the Account used for running the application pool.<\/span><\/li>\n<\/ol>\n<\/li>\n
            4. In the Database Name and Authentication <\/strong>section:<\/span>\n
                \n
              1. In Database name <\/strong>type the desired name of the database (later will be removed).<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
              2. On the bottom of the page click OK<\/strong>.<\/span><\/li>\n
              3. On the Application created <\/strong>screen, click the OK<\/strong> button.<\/span><\/li>\n<\/ol>\n

                To transfer content database to the new server, follow this steps:<\/span><\/p>\n

                  \n
                1. On SBS Server lunch SQL 2005 Management studio<\/strong> as Administrator.<\/span><\/li>\n
                2. In Connect to Server window in Server Name type: \\.pipeMSSQL$MICROSOFT##SSEEsqlquery <\/span>and click Connect<\/strong>.<\/span><\/li>\n
                3. Expand Databases and right-click on ShareWebDB<\/strong>, then click to Task, Backup\u2026<\/strong><\/span><\/li>\n
                4. In BackUp Database <\/strong>window, under Backup destination<\/strong>, select Disk<\/strong> and click Add\u2026<\/strong> to select backup file name.<\/span><\/li>\n
                5. Click OK<\/strong> and wait the job to complete.<\/span><\/li>\n
                6. Transfer the backup file to the new server<\/span><\/li>\n
                7. On the new server run SQL 2008R2 Management studio <\/strong>as Administrator (or another version of the supported SQL server).<\/span><\/li>\n
                8. Connect to desired instance and right-click on databases.<\/span><\/li>\n
                9. Select Restore Databases\u2026<\/strong><\/span><\/li>\n
                10. In Restore Database <\/strong>window add parameters do this:<\/span>\n
                    \n
                  1. In To Database <\/strong>write the name of database to restore \u2013 ShareWebDB<\/strong>.<\/span><\/li>\n
                  2. In Source for Restore <\/strong>select From Device <\/strong>and use the button (\u2026<\/strong>) to select the backup file of database.<\/span><\/li>\n<\/ol>\n<\/li>\n
                  3. Click OK<\/strong> and wait that task complete.<\/span><\/li>\n<\/ol>\n

                    To transfer content to new server we will use the attach database method. This could be done using this steps:<\/span><\/p>\n

                      \n
                    1. Go to Start, All Programs, SharePoint 2010 Products and run SharePoint 2010 Management Shell <\/strong>as Administrator.<\/span><\/li>\n
                    2. In Shell type Test-SPContentDatabase -name ShareWebDB -WebApplication http:\/\/<SITE_NAME>:80<\/span> (where <SITE_NAME><\/span> is the name of the Web Application and ShareWebDB is the name of the transferred database).<\/span><\/li>\n
                    3. It is all normal, if you don\u2019t have any output.<\/span><\/li>\n
                    4. In Shell type\u00a0 Mount-SPContentDatabase -WebApplication http:\/\/<SITE_NAME> sharewebdb <\/span>(where <SITE_NAME><\/span> is the name of the Web Application and ShareWebDB is the name of the\u00a0 transferred database).<\/span><\/li>\n
                    5. Check in Internet Explorer for the availability of site http:\/\/<SITE_NAME>.<\/span><\/span><\/li>\n
                    6. Verify the migrated content by browsing the web site.<\/span><\/li>\n
                    7. On the web site go to Site Settings <\/strong>and select Visual Upgrade<\/strong>.<\/span><\/li>\n
                    8. In Visual Upgrade <\/strong>window, in Visual Upgrade section, select Update the user interface <\/strong>and click OK<\/strong>.<\/span><\/li>\n<\/ol>\n

                      \u00a0<\/span><\/p>\n

                      Migrate from SBS 2008 or 2011 (Part 4)<\/a><\/p>\n

                      Migrate from SBS 2008 or 2011 (Part 2)<\/a>.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

                      Migrate SharePoint Data (Optional) This step is an optional. If you are using SBS SharePoint, you might wish to migrate it. SBS deployments that don\u2019t use this component, can skip this step. You will be able to attach a content database to a destination server only if the version of SBS SharePoint is SP2 or […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,11,14,15],"tags":[18,24,40],"class_list":["post-278","post","type-post","status-publish","format-standard","hentry","category-exchange-server","category-terminal-server","category-windows-sbs-server","category-windows-server","tag-exchange","tag-small-business-server","tag-windows-server"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/em-soft.si\/myblog\/elvis\/index.php?rest_route=\/wp\/v2\/posts\/278","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/em-soft.si\/myblog\/elvis\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/em-soft.si\/myblog\/elvis\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/em-soft.si\/myblog\/elvis\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/em-soft.si\/myblog\/elvis\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=278"}],"version-history":[{"count":0,"href":"https:\/\/em-soft.si\/myblog\/elvis\/index.php?rest_route=\/wp\/v2\/posts\/278\/revisions"}],"wp:attachment":[{"href":"https:\/\/em-soft.si\/myblog\/elvis\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/em-soft.si\/myblog\/elvis\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/em-soft.si\/myblog\/elvis\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}