November 29, 2016 at 8:11 am
I posted this on the 2008 admin forum, but thought I would place it here also.
I am putting together a "recovery" plan if hardware fails, and since the business allows 120 minute recovery window,
I plan to do full and log backup restores of the production databases instead of using an HA technique. I know,
I can use log shipping, but cost of additional hardware prevents that, so here is my question.
The production databases are on version 2008 R2. The plan is to do restores from the 2008 R2 backups to version 2012
that is on a standby server. I will definitely not change the compatibility setting on the databases. Users will then
utilize those databases until the hardware is fixed. Can I perform backup of the databases on the standby server (version
2012 but compatibility set to 2008 R2) and restore that backup to the 2008 R2 database on the production (now fixed) server?
November 29, 2016 at 8:20 am
Please don't post multiple threads for the same question.
No replies here. Replies to http://www.sqlservercentral.com/Forums/Topic1838679-1550-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2016 at 10:18 am
Normally I would agree, but in this case I was going across two versions. That being said, I have received my answer so no need for anyone on this forum to respond. Thanks!
November 29, 2016 at 11:39 am
trhorner (11/29/2016)
Normally I would agree, but in this case I was going across two versions. That being said, I have received my answer so no need for anyone on this forum to respond. Thanks!
Crossing versions is no reason to cross post. If you look up above the thread you will see a navigation link called Recent Posts. Most of us that answers questions use that to find new posts that may need help. That's how we find the cross posts.
November 29, 2016 at 1:13 pm
trhorner (11/29/2016)
Normally I would agree, but in this case I was going across two versions.
Two, three, four versions, same thing. Multiple threads means mixed up replies, answers being posted to answered questions. Pick the best forum, put the thread there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply