1

I have a requirement to setup a warm standby from an SQL Enterprise 2012 SP1 server. I can only use log shipping.

I understand that versions have to be the same for the STANDBY option to work.

Question is - can I restore from SQL 2012 SP1 to 2012 SP3 and use standby mode? Or is that counted as a different version?

And if so, can I log ship from enterprise to standard for example?

2

Question is - can I restore from SQL 2012 SP1 to 2012 SP3 and use standby mode? Or is that counted as a different version?

Yes you can restore the user database backup and this would be possible because version remains same, although this is NOT the recommended approach. Ideally the service pack level should be same. After you have done the restore please plan to upgrade the primary server to SP3 ASAP.

And if so, can I log ship from enterprise to standard for example?

Yes, subject to condition the backup does not includes enterprise features data or the time you took backup of enterprise DB it should not be using any enterprise features other wise restore on standard will fail. To see whether enterprise features are used query enterprise DB with

select * from sys.dm_db_persisted_sku_features
  • Thanks! Confirmed working with 2012 SP3 Standard. Your help is much appreciated. – James Oct 21 '16 at 22:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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