June 26, 2013 at 3:06 am
i know logshipping is not supported as sql server 2012 (primary) and sql server2008 r2 (secondary).
when i am configuring log shipping between sql server 2008 r2 (primary) and sql server 2012 (secondary) i got the below error. any ideas on this.
as far as i know logshipping is not supported as sql server 2012 (primary) and sql server2008 r2 (secondary).
System.Data.SqlClient.SqlError: This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY. (Microsoft.SqlServer.Smo)
------------------------------
can some one throw some light on this.
does logshipping or mirroring is supported between different versions of sql or not.
doe logshipping or mirrroring is supported between different editions of sql or not.
June 26, 2013 at 3:47 am
You need to use the NORECOVERY mode for the restore. The upgrade occurs at recovery point, which is why you can't use STANDBY.
Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply