Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am creating log shipping for two databases, db1 and db2. It will be from SQL Server 2008 r2 to newer version, SQL Server 2012

On the SQL 2008R2, they are both dbi_version = 661:

DBCC TRACEON (3604);
GO DBCC PAGE (db1, 1, 9, 3); GO DBCC TRACEOFF (3604);

I restore them in standby mode:

RESTORE DATABASE db1 FROM DISK = 'Q:\db1.bak' WITH STANDBY = N'R:\SQLLog\db1.undo'

One of them restores ok, with upgrade, and another one is giving me error:

“This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY.“

share|improve this question
add comment

1 Answer 1

up vote 4 down vote accepted

WITH STANDBY is only supported when both SQL Servers are the same version.

You can only use WITH NORECOVERY

An alternative if you need read access to the destination databases, is to use replication.

share|improve this answer
    
8 databases were restored with standby and only two gave me an error. We will continue to use 8 unsupported databases WITH STANDBY and other two will be WITH NORECOVERY. And if one of 8 unsupported databases in a future will error out, we would set replication. –  ob213 Dec 16 '13 at 16:32
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.