Post reply

Custom Log shipping from SQL 7 to a SQL 2000 server

  • September 29, 2004 at 11:18 am

    #109144

    Hi,

    I am having a problem with my custom Log Shipping from a sql 7 to a sql 2000 box. SQL Server will not let me restore the database with the "NORECOVERY" option so I can apply transaction logs to it. I guess it needs to convert the database to a sql 2000 DB.

    1. Any suggestions on how I can do log shipping between the 2 servers?

    2. Can I just install SQL 7 on the SQL 2000 box (have both versions running)?

    Thanks for you help!

     

  • September 29, 2004 at 1:13 pm

    #524826

    I'm not having trouble with the norecovery option on sql2k. The upgrade process only happens when the 'with recovery' option is selected. What's the syntax you're using?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply