Wednesday, February 15, 2012

Edition Compatibility

Hi all,
I am under the impression that one can not Log Ship from enterprise edition to standard edition. Anyone have any documentation they can point me to?
TIA,
SQLPoet

The problem is Log Shipping comes with only the Enterprise edition not the standard but you can use the backup and restore wizard to do most of what you do with Log shipping. Try the links below for Microsoft provided Log shipping tutorial and another with the advantages and disadvantages of Log Shipping. Hope this helps.
http://www.informit.com/articles/article.asp?p=331402&rl=1

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx

|||Thanks Gift...
I do understand that it comes with enterprise. The question is can I log ship from enterprise to standard if I never plan to promote the standard copy?
SQLPoet|||The answer is no because Log Shipping is not part of the Standard Edition. That is the reason I gave you the first link because it explains the alternative of the none production Developer edition which comes with Log Shipping. Hope this helps.

No comments:

Post a Comment