December 8, 2015 at 7:34 am
Hi all
We're about to upgrade two servers from SQL 2005 to SQL 2012 (not sure of the edition).
Now, we already have 2 servers running SQL2012, 1 on Developer Edition and the other on Business Intelligence Edition.
Assuming the SQL2005 servers are upgraded to SQL2012 Business Intelligence Edition, will we be able to mirror to the 2012 Development Edition server?
According to MS, it looks as though we won't but I'd like to double-check with someone who's actually tried it on here.
Any help on this would be greatly appreciated.
Regards
Richard
December 8, 2015 at 8:58 am
richardmgreen1 (12/8/2015)
Hi allWe're about to upgrade two servers from SQL 2005 to SQL 2012 (not sure of the edition).
You're going to need to know this for the upgrade 😉
Please check the edition and post back
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2015 at 2:09 am
I'm assuming the new servers will be on the Business Intelligence Edition.
If my assumption is correct, will mirroring work?
December 10, 2015 at 3:47 am
richardmgreen1 (12/10/2015)
I'm assuming the new servers will be on the Business Intelligence Edition.If my assumption is correct, will mirroring work?
Yes, mirroring is a feature of the BI edition
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
December 10, 2015 at 3:55 am
Mirroring is deprecated. You should use AlwaysOn Availability Groups if you're upgrading to SQL Server 2012 or later.
John
December 10, 2015 at 5:00 am
John Mitchell-245523 (12/10/2015)
Mirroring is deprecated. You should use AlwaysOn Availability Groups if you're upgrading to SQL Server 2012 or later.John
If you're lucky enough to have Enterprise Edition.
December 10, 2015 at 5:33 am
Ooh yes, I take it back. I assumed it would be available in BI Edition also, but it isn't.
John
December 10, 2015 at 6:38 am
I don't think we'll be getting Enterprise edition but I'll check.
My concern is that Business Intelligence edition won't mirror to Developer edition.
December 10, 2015 at 6:42 am
richardmgreen1 (12/10/2015)
I don't think we'll be getting Enterprise edition but I'll check.My concern is that Business Intelligence edition won't mirror to Developer edition.
Forgive my ignorance but why mirror to the developer edition? What is the business reasoning behind this? Developer edition cannot be used in a production environment so when failing over the mirror, you will be running your live database(s) on a none production licensed server and thus be in breach of the T&C's.
December 10, 2015 at 8:51 am
We aren't using it for failover.
The mirrors will be snapshotted for use in reporting.
We need the data to run various reports on (that's on thr BI Edition server).
The mirror to the Developer edition server is for test purposes but using the same data (so we can estinate the length of time to run any new reports, tweak code for perforamnce boosts, etc.)
December 10, 2015 at 9:12 am
Ah ok, that makes more sense.
In theory it should work, but as John has already mentioned mirroring is now a depreciated feature.
I would take a look at Log Shipping instead in read-only mode with disconnect users on restore.
December 10, 2015 at 9:17 am
Thanks folks, looks like we've got some decisions to make.
Just out of curiosity, what the minimum amount of time between log ships (if that's a sensible questions?)?
December 10, 2015 at 9:22 am
Here is a useful thread
http://www.sqlservercentral.com/Forums/Topic120198-71-1.aspx
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
December 10, 2015 at 9:27 am
richardmgreen1 (12/10/2015)
We aren't using it for failover.The mirrors will be snapshotted for use in reporting.
We need the data to run various reports on (that's on thr BI Edition server).
The mirror to the Developer edition server is for test purposes but using the same data (so we can estinate the length of time to run any new reports, tweak code for perforamnce boosts, etc.)
I'm pretty sure the secondary server still needs to be licensed for that.
December 11, 2015 at 1:49 am
Gazareth (12/10/2015)
richardmgreen1 (12/10/2015)
We aren't using it for failover.The mirrors will be snapshotted for use in reporting.
We need the data to run various reports on (that's on thr BI Edition server).
The mirror to the Developer edition server is for test purposes but using the same data (so we can estinate the length of time to run any new reports, tweak code for perforamnce boosts, etc.)
I'm pretty sure the secondary server still needs to be licensed for that.
Licensing dev / tests environments is as a tricky one as you need to limit who/what can access it.
Anyone connecting to a dev instance must have a dev license or a valid MSDN subscription
But other than that if you have people who don't have a valid developer licenses accessing non-prod environments then they need to be licensed as live setups, be it core / server&cal methods
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply