How can we help you today? How can we help you today?

Log shipping between SQL2000 (pub) and SQL2005(sub)??

Being new to the RedGate product line, I am wondering if someone can tell me if Backup Pro supports log shipping between a SQL2000 publisher and SQL2005 subscriber?

I know it's not possible natively, nor is it with Quest' Litespeed, but I wanted to check with RedGate.

Thanks everyone for the info.

Chris
ctrawick
0

Comments

2 comments

Sort by
  • Brian Donahue
    Hi,

    I believe it should -- you can restore a SQL 2000 backup to a SQL 2005 server. Not the other way round, though!

    Chances are if it doesn't work in Litespeed or native, it won't work in SQL Backup either. The limitation is on the SQL Server end, and third-party backup programs are still going to share any limitations imposed by the server platform.
    Brian Donahue
    0
  • James Moore
    You probably wont be able to put the databases in STANDBY to start with as SQL Server does not support RESTORE .. STANDBY and an upgrade but afterwards you can do it with NO RECOVERY.

    I've never tried doing a full RESTORE with NO RECOVERY followed by a RESTORE WITH STANDBY followed by RESTORE LOG with STANDBY - this might be one way of setting up log shipping doing an upgrade with standby.

    - James
    James Moore
    0

Add comment

Please sign in to leave a comment.