Log shipping in sql server 2000

  • the principal and process for log shipping was the same in SQL2000 but the set up gui was different. It was also only available in the enterprise edition.

    If you have standard edition you would have to create your own process.

    ---------------------------------------------------------------------

  • ok i want the process method in gui

  • i am planning to configure primary in 2000 and secondary in 2005

    how can i do this

  • gantavasu (3/18/2013)


    ok i want the process method in gui

    http://msdn.microsoft.com/en-us/library/aa496029(v=sql.80).aspx

    ---------------------------------------------------------------------

  • gantavasu (3/18/2013)


    i am planning to configure primary in 2000 and secondary in 2005

    how can i do this

    same process but what are you aiming to acheive here? If the secondary is intended to be your failover you know you won't be able to fail back as the database will be upgraded if you ever bring it on-line. You then will not be able to go back to SQL2000 as backups from 2005 to 2000 do not work.

    Until you want to recover the 2005 database all logshipping restores will have to be restored in norecovery mode.

    ---------------------------------------------------------------------

Viewing 5 posts - 1 through 6 (of 6 total)

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