Home » SQL Server

Log shipping 2008 SP1 to 2008 R2 using WITH STANDBY causes error

I am log shipping form SQL Server 2008 SP1 to SQL Server 2008 R2. When I restore the log using WITH NORECOVERY it works fine but I wanted to put the database into STANDBY mode so tried to restore the log WITH STANDBY and I get the following 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.

What upgrade needs to be performed on the database?


4 Answers Found


Answer 1

Upgrading from SQL Server 2008 SP1 to SQL Server 2008 R2.

These are considered to be different versions, and you can't do a with standby when you go between different versions.


Answer 2

To be honest, it defies credibility as they are both 2008, the source and destination databases are both set to Compatibility Level = SQL Server 2008 (100) so you'd expect, well I'd expect (I know that defies all sense and sensibility to expect the obvious from MS) that the database wouldn't need to be upgraded. Despite the Compatibility Level being the same, quite obviously it really isn't so MS should have added a new level.

Fortunately this was a POC to see if log shipping is possible between 2008 SP1 and 2008 R2, which basically it is providing you don't want to put the destination database into standby mode. Great for testing! <sigh>

Anyway thanks Hilary.


Answer 3

Hey Michael,

       The thing that needs to be upgraded is the DBI_Version, DB Internal Version, of the database in question.  Each Page has the version number of SQL (major version) in the page header.  SQL 2008 is DBI 655 2008 R2 is DBI 661.  You can use mirroring to upgrade and move a database, and you may be able to restore with norecovery, but standby or snapshots of a mirrored database won't work because you've got one version of SQL reading attempting to read like another version.  the DBI number must be upgraded.



Answer 4

Ah that explains a lot, thanks Brad.


<< Previous      Next >>

Microsoft   |   Windows   |   Visual Studio   |   Sharepoint   |   Azure