I'm trying to configure logshipping from sql server 2008 r2 (database compatibility level 100) to sql server 2012; however, the setup is failing with this error.
Msg 3180, Level 16, State 1, Line 1
This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY
I thought you can lopshipping from a lower version to a higher version of sql without any issue?
With this kind of error, what exactly should I do?