March 24, 2003 at 1:36 pm
Can Log Shipping on a SQL2K server use logs coming from a SQL 7 Server?
Thanks.
Nick DeAngelo
March 24, 2003 at 1:42 pm
The question really is, can you restore a backup from SQL 7 to 2K ? That's all log shipping does - no magic.
John Zacharkan
John Zacharkan
March 24, 2003 at 1:46 pm
John,
Thanks for your quick reply - actually, it's a bit different. I know you can restore a SQL 7 db into SQL2K server, and some conversion is done during the process - which is why I'm wondering if it will restore transactions (not the full db) into a SQL 2K database. Thanks.
March 24, 2003 at 2:05 pm
Gottcha, so you restore the database from 7 to 2K and left it in standby, what happens when you try restoring the first transaction log.
Never mind, I'm setting up that situation now, I'll let you what happens.
quote:
John,Thanks for your quick reply - actually, it's a bit different. I know you can restore a SQL 7 db into SQL2K server, and some conversion is done during the process - which is why I'm wondering if it will restore transactions (not the full db) into a SQL 2K database. Thanks.
John Zacharkan
John Zacharkan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply