Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Wednesday, October 22, 2014 9:20 PM
Points: 18, Visits: 293
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 11:17 PM
Points: 6,490, Visits: 13,968
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: Wednesday, October 22, 2014 9:20 PM
Points: 18, Visits: 293
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 11:17 PM
Points: 6,490, Visits: 13,968
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 11:17 PM
Points: 6,490, Visits: 13,968
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