Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2014 AG with 2012 Replica Expand / Collapse
Author
Message
Posted Wednesday, May 7, 2014 12:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 12:15 AM
Points: 19, Visits: 354
Hi all,

Is it possible to have a 2014 Availability Group with a read-only secondary Replica in SQL 2012. The replica will never be failed over to or written to, just used as a readable replica.

Thanks in advance :)
Post #1568297
Posted Wednesday, May 7, 2014 3:35 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:26 AM
Points: 8,098, Visits: 16,276
slim.richard (5/7/2014)
Hi all,

Is it possible to have a 2014 Availability Group with a read-only secondary Replica in SQL 2012. The replica will never be failed over to or written to, just used as a readable replica.

Thanks in advance :)

No, you cannot replicate down versions. You could have a 2012 AO group with a 2014 replica, this would be used for migration purposes.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1568342
Posted Wednesday, May 7, 2014 11:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 12:15 AM
Points: 19, Visits: 354
Thanks for that. It was what i was expecting but haven't found anything in the documentation.

Cheers.
Post #1568766
Posted Thursday, May 8, 2014 12:09 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:26 AM
Points: 8,098, Visits: 16,276
No, it should be detailed under backup\restore databases. You cannot move down versions, only upwards

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1568772
Posted Thursday, May 8, 2014 7:30 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:26 AM
Points: 8,098, Visits: 16,276
Found it. The "Compatibility Support" section of this link details the following

RESTORE (Transact-SQL)
Note
No SQL Server backup be restored to an earlier version of SQL Server than the version on which the backup was created.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1568883
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse