Avatar of BeerTime
BeerTime
Flag for Canada asked on

SharePoint 2013/ SQL 2014 - content database backup and restore from Prod to Dev

hi everyone,

I have SharePoint 2013 and SQL 2014 server in PROD and DEV environments (separate systems for each environments). I wanted to know the best practice for backing up the SharePoint content database from Prod and restoring to Dev environment (refreshing the data). My understanding is that when refreshing the SQL databases the content will be overwritten but can still use the same site within SharePoint - please help!

Thanks in advance.
Microsoft SharePointMicrosoft SQL Server

Avatar of undefined
Last Comment
Walter Curtis

8/22/2022 - Mon
SOLUTION
Walter Curtis

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
Greg Burns

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Walter Curtis

Again, what are you trying to do?
Greg Burns

He said he wants to refresh the content on dev with data from prod. I think a site collection restore would accomplish the same thing without having the overhead of a sql restore.
Walter Curtis

@ Greg - Thanks for the info, there are a lot of other possibilities however, so just wondering what he has in mind. Might help in offering him an accurate solution.

...
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Greg Burns

Of course. There's lots of ways to accomplish this. You could also look at third party products like DocAve Replicator. But it's spendy.
BeerTime

ASKER
Hi Walter and Greg, thanks so much for your feedback. We are currently having some search related issues with SharePoint in PROD, the purpose of this exercise is to refresh the content database so we can troubleshoot the issue safely in DEV environment. Thanks for pointing out that the SharePoint version, sites and overwrite options will have to be considered to accomplish this task. I am leaning toward Greg's suggestion of doing.

1. Enumerate and backup all site collections in a content database.
 2. Move the backup files to the dev farm
 3. Restore each site collection to a web app in the dev farm, with overwrite.

Please let me know if there is anything else I should watch out for to carry out this task. Thanks again!
Walter Curtis

My answers were geared to your question.

Now knowing what you exactly want to do, yes SharePoint backup and restore would do what you want to do, but would require a lot of manual labor. If you have a large farm, and you don't care if data is overwritten, you could do a db copy and restore from your prod farm to your dev farm. You could also do some things with a backup file of your productions database, attaching it to your dev farm and mount the database in your dev farm. Of course, PowerShell would be very useful while you do this.

After evaluating how many site collections you have will be useful to determining what direction to go in.

Good luck...
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
BeerTime

ASKER
Thanks again for your help guys!
Walter Curtis

Hope all worked out well for you!

Thanks