May 14
Upgrade to SharePoint 2010 "Content Database Attach Upgrade Process"

Here are some steps that will hopefully upgrade your 2007 SharePoint environment to the new version of SharePoint 2010.

STEP 1
P
RE UPGRADE CHECK

First run the preupgrade check on your 2007 SharePoint environment
Run C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\BIN\stsadm –o preupgradecheck as an Adminstrator (i.e. Run As) 

STEP 2
RECREATE CONTENT DATABASES ON THE NEW FARM
BY R
ESTORING A COPY OF THE 2007 CONTENT DATABASE TO THE 2010 DATABASE
 

 

On the new SharePoint 2010 Farm you will need to create a new web application on the new SP2010 farm just as if you were creating a new web application.
  • Next, remove the content database
  • Restart the Database Server or Services to gurantee the DB is not in ues anymore.

ON THE OLD DATABASE SET DB TO READ-ONLY   

  • Right-click the database, and then click Properties.
  • Click Options > Set Database Read-Only to True.

ON THE OLD SQL SERVER BACKUP THE WSS CONTENT DB

  • Take SQL backups of the content DB's from the old farm and copied those to the new SQL server.
    • Backup database WSS_CONTENT to disk = 'Drive:\Backup\WSS_CONTENT_FULL.BAK'

      Or

    • Navigate to the Databases > WSS_CONTENT
      • Right click the DB >Tasks > Back Up...

    • Overwrite all existing backup sets

    • Take the SQL backup of the WSS_CONTENT_FULL DB from the old SQL server DB and copy this to the new SQL 2008 R2 server.

ON THE NEW SQL SERVER   

  • Right-click the ROOT database, and then click Restore Database...
  • Make certain to point to the Database you deleted previously
  • Choose From device:
    • Select the path where the .bak is located
  • Check the Restore option under the Select the backup sets to restore

    • Choose Options
      • Make certain to overwrite the exiting database (WITH REPLACE) option is checked

     

SHAREPOINT WFE'S (SP2010)

  • If you are not using the SharePoint 2010 Management Shell you will need to add the SharePoint Snap-In to Windows PowerShell - http://msdn.microsoft.com/en-us/library/ee537913.aspx

    • Test-SPContentDatabase Windows PowerShell cmdlet.  This cmdlet will test and verify that any custom components that are required for this content database has been installed and configured in the SharePoint 2010 environment.
      • Test-SPContentDatabase –Name <database name> -WebApplication <URL>

    • These can be addressed now or post-upgrade

     

  • Add the Content Database to the Web Application
    • Verify the database is set to read/write
    • Run stsadm.exe as an Admisitrator
    • cd C:\Program Files\Common Files\microsoft shared\Web Server Extensions\14\BIN
      • stsadm -o addcontentdb -url <URL> -databasename <database name
    • stsadm -o addcontentdb -url http://tst.sp.nsss.net -databasename WSS_CONTENT_NSSS_TST

         

 

     

  • After a successful migration, redeploy all solutions globally.

Comments

There are no comments for this post.

 ‭(Hidden)‬ Blog Tools