Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2011-05-09
Medium Priority
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
  • 2

Expert Comment

ID: 35720954
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

ID: 35721032
Where can I find information to walk me through using stsadmin to attach the data base?

Accepted Solution

ufarooq earned 2000 total points
ID: 35721201
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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
Integration Management Part 2
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses
Course of the Month11 days, 6 hours left to enroll

572 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