Migrating MOSS 2007 content database to MOSS 2007 SP2 RRS feed

  • Question

  • I currently have an installation of MOSS 2007 on one server and I would like to now migrate my MOSS 2007 content database to another installation of MOSS 2007 SP2.

    Since both installations of MOSS exist at different service pack levels, do I need to do anything to the original content database before re-attaching it to the new MOSS 2007 SP2 installation or will the process of attaching the content database to my new MOSS 2007 SP2 installation automatically handle any schema upgrades etc. related to the service pack installation that are required?



    Wednesday, March 24, 2010 1:09 PM


  • Hi,

    this should work without any problem

    1) Find the content Database, These are listed under Central Admin->Application Management->Site Collection List
    2) Backup the content database,
    You could alternatively detach it, and copy it. Just doing a backup in SQL Server Management studio is easier.
    3) Restore content database to the new SQL server (I suppose are going to move to a new DB server)
    Copy the BAK file to new server. Create an empty DB in Management Studio, restore from backup, you may need to change an option in the "options" tab of the restore dialog to get it to work. (Overwrite db).
    4) Create Web App on new Server
    Central Admin->Application Management->Create or extend Web App->Create New Web App.
    5) Associate restored DB with new Web App
    Central Admin->Application Management-> SharePoint Web Application Management->Content Databases->
    Remove Content Database from your new web app.

    Now use STSADM to add restored DB to this web app
    c:\program files\common files\microsoft shared\web server extentions\12\bin on new server is where you can find the STSADM.
    run this command from there.
    stsadm -o addcontentdb -url http://yourwebapp:port -databasename yourcontentdb -databaseserver yoursqlserver
    6) Run ISSRESET from command prompt

    Best Regards, Ammar MCT http://ahmed-ammar.blogspot.com Posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by ssvaidya Wednesday, March 24, 2010 7:52 PM
    Wednesday, March 24, 2010 1:17 PM