Linking Sites to existing content DB's

We recently had a sharepoint server go down and attempted to rebuild a server using the existing config db which was a no go.  So what we decided to do is create a new server, server farm and pretty much new everything.

All of our existing data is contained in our WSS_conten db.  We were able to rebuild the entire server from scratch and added the exisiting content db to our site but are not able to link to the data contained with in it.  Is that even possible?  Is there a way to either import the existing data into the site or merge with another content db?

Not sure what to do beyond this point as I'm an amateur at best with sharepoint.

We are using Sharepoint server 2007 sp2 on windows server 2008 R2.

Any help would be greatly appreciated.

Thanks
40hzAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brad HoweDevOps ManagerCommented:
Yes, you can move Sharepoint content DBs everywhere :)

http://technet.microsoft.com/en-us/library/cc262792.aspx

One the new server did you re-create you webapplication from stractch?

How did you add your existing contentDB to your restored webapp? Did you use central Adminstration?

Please provide all the steps you took,
Cheers,
Hades666
0
40hzAuthor Commented:
I'll do my best to describe as tasks were shared.  I'm glad to hear that you can move db's because i would die where I sit if we lost all that data lol.

1.installed all components on server.
2.created new server farm config/db
3.created new web apps, i believe three in total (portal, personal and admin) with new content db's as you are forced to do so in config
4.added wss_content db to our portal site(http://intranet, our main site collection).  this site has the same host name as our existing sharepoint config.

I believe that is where we are at, at the moment.

We created a new webapp of the same name using central admin/app management/content db's and added it to the web app.  if i absolutely need too, i can get the existing webapp but cannot use the web ui at all and the site is non-functional as it sits.

I was reading this info:

http://www.eggheadcafe.com/software/aspnet/33138798/failure-trying-to-synch-w.aspx

Is that the route i want to go?

Thanks for the super fast reply, i think it's time for a frosty brew :)
0
Brad HoweDevOps ManagerCommented:
On route home now.

1. Do you have a Sql backup of the current/proper contentDB?
2. When you created the webapp, did you us the same content DB name as the existing server?

Let me know :)
Hades666
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

40hzAuthor Commented:
Yes i do and will make a manual backup as we speak.  When the webapp was created, a new content db was created with a new/different name than the exisiting server.

Our old content db is sitting there with no friends lol.
0
40hzAuthor Commented:
I got it to work by following this site's walkthrough:

http://alkalony.wordpress.com/2009/08/25/add-existing-content-database-to-a-site-collection-using-stsadm/

This relinked the Content DB which had also contained our original sites, libraries in a addition to our data.  This makes rebuilding much more tangible.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Brad HoweDevOps ManagerCommented:
Weekend was to busy to use a PC, glad you got it working.
Hades666
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.