InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 16:59:56 GMT20http://www.sqlservercentral.com/Forums/Topic1404096-1549-1.aspxYes, or downgrade your secondary to 2008 R2.Tue, 22 Jan 2013 08:45:43 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1404096-1549-1.aspxThanks for your reponse.So i need upgrade my Primary to 2012 for my readOnly Database on my secondary server.Tue, 22 Jan 2013 08:44:11 GMTrenaud.quintinhttp://www.sqlservercentral.com/Forums/Topic1404096-1549-1.aspxYes, 2008 R2 to 2012 will work, but it can only be used for 1 way, once you make the 2012 instance active (WITH RECOVERY) you will no longer be able to logship back to 2008 R2 (role switching will not be allowed back to make 2008R2 primary).You cannot put a database into STANDBY mode when crossing version, it has to be in NORECOVERY mode.If you need the secondary copy to be in STANDBY then primary server will need to be 2012 or secondary server will need to be 2008 R2Tue, 22 Jan 2013 08:30:14 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1404096-1549-1.aspxHello,Do you know if log shipping is functionning in this case :SQL server 2008 R2 --> SQL server 2012 SP1 ?In StandBy ModeBecause when i configure log shipping on my 2008 R2, i have this message for the first Full backup restore :"System.Data.SqlClient.SqlError: This Backup cannot be restore with WITH STANDBY because it's need an update car la mise à niveau d'une base de données est nécessaire. Réexécutez RESTORE sans WITH STANDBY. (Microsoft.SqlServer.Smo)"Any idear ?Tue, 22 Jan 2013 08:21:45 GMTrenaud.quintinhttp://www.sqlservercentral.com/Forums/Topic1404096-1549-1.aspxLogshipping is basically doing backup and restore, so the same backup and restore rules apply, you can do it to the same version or a higher version.But once you have restored to a higher version and made it active, you cannot logship back as you will be going from higer version to lower version which cannot be done. So best in a logshipping environment to have the same edition and level of SQL on both source and destination.Logshipping and backup restore doesn't care if the server is 32 bit or 64 bit.SQL 2008 to SQL 2008, logshipping will work ok, can fail backSQL 2008 R2 to SQL 2008 R2, logshipping will work ok, can fail backSQL 2008 to SQL 2008 R2, logshipping will work ok, CANNOT fail backSQL 2008 R2 to SQL 2008, logshipping will NOT work,Tue, 08 Jan 2013 04:13:02 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1404096-1549-1.aspxok, Thanks...the same version can possible to configure for log shipping...not concern with 32 or 64 bits and 2008 R2Tue, 08 Jan 2013 04:05:15 GMTananda.murugesanhttp://www.sqlservercentral.com/Forums/Topic1404096-1549-1.aspx[quote][b]ananda.murugesan (1/8/2013)[/b][hr]Hi,Can we able to configure for LOG SHIPPING by two different systemt architecture?source server-------------System type – windows 2008 R2 enterprise edition 64 bit operating systemDatabase – MS SQL SERVER 2008 Enterprise edition 64 bitDestination server--------------------System type – windows 2008 enterprise edition 32 bit operating systemDatabase – MS SQL SERVER 2008 Enterprise edition 32 bitThanksananda[/quote]Your original post says that both SQL servers are SQL 2008 Enterprise, 1 is 64 bit 1 is 32bit.You detail that the operating system is 2008R2 on one and 2008 on the other.So what is it, are the SQL Servers different versions or is it just the OS, or is it both?Tue, 08 Jan 2013 03:52:13 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1404096-1549-1.aspxI have doubt, destination server - SQL 2008 32 bit enterprise edition, it is not higher then source server.source server - SQL 2008 R2 64 bit enterprise edition.Pl. confirm.thanksTue, 08 Jan 2013 03:50:15 GMTananda.murugesanhttp://www.sqlservercentral.com/Forums/Topic1404096-1549-1.aspxYes if the destination is of the same SQL version or higher.Log shipping doesnt matter if its 32 bit or 64 bit.Tue, 08 Jan 2013 03:46:09 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1404096-1549-1.aspxHi,Can we able to configure for LOG SHIPPING by two different systemt architecture?source server-------------System type – windows 2008 R2 enterprise edition 64 bit operating systemDatabase – MS SQL SERVER 2008 Enterprise edition 64 bitDestination server--------------------System type – windows 2008 enterprise edition 32 bit operating systemDatabase – MS SQL SERVER 2008 Enterprise edition 32 bitThanksanandaTue, 08 Jan 2013 03:32:08 GMTananda.murugesan