Move a SharePoint Content Database / Deploy sharepoint site

our Official website (https://zonixsoft.com)

You have two initial options, doing a backup and restore within MOSS to move the data, or doing it at the SQL/STSADM level.  I prefer the latter, as it isn’t nearly as inclined to fail and leaves you with more flexibility.

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 2005 Management studio is easier.

3) Restore content database to new 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 filescommon filesmicrosoft sharedweb server extentions12bin 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.


Bookmark and Share

8 thoughts on “Move a SharePoint Content Database / Deploy sharepoint site

  1. Kalpesh

    Hi,

    Please explain how to deploy web application on other server. Using above technic the customization I have done like added ASP.Net application’s aspx pages and dll in the sharepoint application is not reflected on the server where I deploy the back up.

  2. Sarah

    After exploring a number of the blog articles on your blog, I really appreciate your technique of blogging.
    I saved as a favorite it to my bookmark website list and will be checking back soon.

    Please visit my website as well and tell me how you feel.

  3. www.maidbrigade.com

    Hey there! Someone in my Facebook group shared this site with us so I came to take a look.
    I’m definitely loving the information. I’m book-marking and
    will be tweeting this to my followers! Terrific blog
    and brilliant design and style.

  4. www.thaitravelexpo.com

    It’s a pity you don’t have a donate button! I’d certainly donate to this superb blog! I guess for now i’ll settle for bookmarking
    and adding your RSS feed to my Google account. I look forward to
    fresh updates and will share this website with my Facebook group.

    Talk soon!

  5. www.thaitravelexpo.com

    It’s a pity you don’t have a donate button! I’d certainly donate to this superb blog! I guess for now i’ll settle for bookmarking
    and adding your RSS feed to my Google account. I look forward to
    fresh updates and will share this website with my Facebook group.

    Talk soon!

  6. Christine

    What you posted made a bunch of sense. But, think on
    this, what if you added a little information? I mean, I don’t wish to tell you how to run your blog, however suppose you added something to possibly grab folk’s
    attention? I mean Move a SharePoint Content Database / Deploy sharepoint site | Zonix Software
    Solutions is a little plain. You should peek at Yahoo’s home page and note how they create post headlines to grab people to click. You might try adding a video or a related picture or two to get readers excited about everything’ve written.
    Just my opinion, it would make your posts a little livelier.

Comments are closed.