Joe's profileJoe Shepherd - Adventure...PhotosBlogListsMore Tools Help

Blog


    October 15

    Migrating Site Collection to new Content Database

     
    At some point in time you will be faced with having to migrate a site collection out from one Content Database and into another. This is actually quite an easy thing to do if you plan for it. In the event that you suspect a Site Collection may need to migrate out to its own content database you can just configure this up front. You see if you only have a single Content Database assigned to your Web Application SharePoint will put all site collections into that single DB. If you add a second content database SharePoint will add any new site collections to the database with the greatest difference between the current number of sites and the maximum number of sites. This is useful if you plan this from the start but what if you already have a site collection that needs to migrate to its own content database?
     
    In order to do that you would need to simply add a new content database, back up the site collection that you would like to migrate to the new database, delete the site collection, then restore it from backup. Do all of this with stsadm.exe. This will automatically place the site collection into the new content database.

    Comments

    Please wait...
    Sorry, the comment you entered is too long. Please shorten it.
    You didn't enter anything. Please try again.
    Sorry, we can't add your comment right now. Please try again later.
    To add a comment, you need permission from your parent. Ask for permission
    Your parent has turned off comments.
    Sorry, we can't delete your comment right now. Please try again later.
    You've exceeded the maximum number of comments that can be left in one day. Please try again in 24 hours.
    Your account has had the ability to leave comments disabled because our systems indicate that you may be spamming other users. If you believe that your account has been disabled in error please contact Windows Live support.
    Complete the security check below to finish leaving your comment.
    The characters you type in the security check must match the characters in the picture or audio.
    Joe Shepherd has turned off comments on this page.

    Trackbacks

    The trackback URL for this entry is:
    http://joeshepherd.spaces.live.com/blog/cns!9AE2097A4A610B63!181.trak
    Weblogs that reference this entry
    • None