1

We have a nightly Production to Staging database sync that failed this morning. I need to copy a backup from 1 Production server to 1 Staging server and I'm not sure of the best way to do it without interrupting services or affect performance.

The backup is 15GB and the servers have a high speed connection between them. Would it be best to simply copy the backup from Production to Staging and perform the restore manually, or would this affect performance too much?

closed as off-topic by mustaccio, hot2use, Erik Darling, RDFozz, McNets Nov 2 '17 at 11:40

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Erik Darling, RDFozz, McNets
If this question can be reworded to fit the rules in the help center, please edit the question.

2

Usually copying your latest database backup (from the production backup location) to an area where you can restore it over the top of your staging area should have no effect on your production database. The only time where this would affect it is if you're storing the backups on the same drive(s) that is hosting the live database, but hopefully you're not. In this instance, the file copy operation will just generate extra, and competing, I/O with your normal database operations.

Your question doesn't provide enough context around how this sync process works, but a 15GB file copy isn't usually large enough (in my experience) to crash a server or cause any severe performance degradation.

  • Apologies for the lack of context, but this answer gives enough information for me to just go ahead and try it. Thanks! – Powellellogram Nov 1 '17 at 14:04

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