Silly question about backup

Question

Silly question about backup

Chitown

Hall of Fame

Points: 3390
More actions
August 29, 2016 at 1:46 pm

#329743

I have a dev server, running on 2014 and a prod which was recently upgraded, running on 2016. Is there a way to restore the backup from 2016 to 2014 without upgrading 2014 to 2016 1st? Sounds like a silly question but no question is dumb question.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

Unfortunately, there's no way to downgrade databases or their backups. You'll need to find another way to replicate prod data in your dev server, or simply upgrade it.

PS. Not a silly or dumb question, IMO.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Chitown Hall of Fame Points: 3390 More actions · Answer 2

We are going to upgrade it next week but developers need the data now to test. I am sure that's not new.

Thanks!

Sue_H SSC Guru Points: 90860 More actions · Answer 3

Sometimes they just need data they haven't trashed. Worth checking - then you can just restore the last backup when it was running 2014.

Sue

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

That is if you are backing up the databases on the dev servers.

Sue_H SSC Guru Points: 90860 More actions · Answer 5

Guess I was thinking I'd hope they have the old production server one from the pre-upgrade, you know backup before the upgrade so that when it all goes to crap and you rollback, etc. Even though it's rare, I shouldn't be thinking. Life is easier that way.

Sue

Chitown Hall of Fame Points: 3390 More actions · Answer 6

Yes, we do take full backups for dev servers every week and full, dif and tlog for Prod. We also have 6 months of backups for prod in place just in case if things go south.