Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I'm in the process of trying to setup a development server for our SharePoint based Intranet. Our current production setup is comprised of two servers: one front-end web server and the SQL instance on our SQL cluster for the database.

My ideal solution, would be to house the database and web front-end on the same development server. I was hoping to make a clone of our current web server, and then restore backup copies of the databases from the cluster instance onto a local instance of SQL.

I was wondering if anyone has attempted, hopefully with success, a similar scenario previously, and could provide some insight on how to get SharePoint talking to a database locally rather than trying to reach out to our cluster. I'm hoping to do this without having to build a whole new SharePoint server -- I want to keep everything as close to the current production setup as possible.

We've already had the production web server cloned, and I've installed a copy of SQL and restored all of the databases. My next step is to get SharePoint to talk to the databases on the local server. That is where I need help. I was thinking of using a SQL Native Client alias for the production server name, and route it to localhost. However, I wasn't sure where all SharePoint was configured to look for a specific database server.

Or, on the opposite end of the spectrum, maybe I'm going about this entirely the wrong way. Maybe I should build out a new SharePoint server and just restore content databases?

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

You're far easier just building the single server farm and restoring the content databases.

Read this thread for a very similar question: Is it possible to migrate and attach a wss 3.0 configuration database to a new Foundation 2010 front-end?

share|improve this answer
    
I was afraid of that. Thanks for the info. –  Jon Dec 1 '11 at 19:52
    
What's to be afraid of, it's the easy option :P –  James Love Dec 1 '11 at 19:52
    
True -- Thanks for the info. I'm marking your reply as the answer. I've seen other articles saying you cannot move config databases, only content databases. –  Jon Dec 2 '11 at 15:44
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.