How do I import a unbacked up Sharepoint 3.0 database to a different server?

Posted on 2011-05-09
Last Modified: 2012-05-11
I have installed SharePoint Services on a Win 2003 server.  I would to use the database from the previous server that is no longer online and has not been backed up.  Is there a way to do this?  If not is there a way I can access the documents that were stored on the database?
Question by:yvepa
    LVL 7

    Expert Comment

    Try to restore your old data base into new environment  , create a web app and remove its default data base that is created at the time of web app creation , now use stsadm command to attach this data base to your new web app . all your sites and contents will show up in the new web app .
    other wise there is not way to search or access  content from unattached data base in MOSS .

    Author Comment

    Where can I find information to walk me through using stsadmin to attach the data base?
    LVL 7

    Accepted Solution

    You can Google this but you might not find exactly what you are looking for. It is pretty simple by the way.
    Back up your old data base using build in SQL tool.
    Move the backup file to new sql server and restore data base in the new sql server using that back up file , using SQL management again .

    go in to your SharePoint .  content databases page and select the existing dat abase the one you created at the time of new web app creation .
    Select that data base and change it to offline and then remove
    Now open up command prompt and change directory to Bin folder to run stsadm command
    run this command
    stsadm.exe -o addcontentdb -url htt://NameOfWebApp -databasename NameOfDatabase
    Hit enter
    This has more detailed steps also

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
    I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now