troubleshooting Question

Copy production Sharepoint server to a test server

Avatar of fertigj
fertigj asked on
Microsoft SharePointMicrosoft SQL Server 2005
4 Comments1 Solution824 ViewsLast Modified:

I am trying to copy a production sharepoint server/db {wss 3.0 v12.0.0.4518/sql2005} to a test lab.  

  Sharepoint -->  Sharepoint-test
  Sharepointdb -->sharepointdb-test

I used stsadm to create a full backup {stsadm -o backup -dir \\someserver\someshare -backupmethod full} and after a little messing around I was
able to get it to finish without errors.   The strange part of this is the backup file is only 5 gigs, but I was expecting something close to 100gbs.  More specifically, the production sharepoint server only has 50gb's free at the moment...and when I tried to save the backup to the local drive stsadmin threw an error saying that it would need 100gb's for the backup.

So assuming my 5gb backup is good {just testing for now},  I setup a test sp box and sp db.   I ran the restore using stsadmin.    When I looked at the web application list, it was showing the restored applications with the production urls.   Will this impact the production environment?   If so how do I go about fixing this?

At this point I know I will prob need to rebuild the test environment, but in the end I need to have a copy that is as close to the production version if possible.   What is the best way to approach this?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros