Post reply

Logshipping

  • February 4, 2009 at 5:41 am

    #134316

    Any difference is there logshipping in 2000 and 2005?

  • February 4, 2009 at 6:31 am

    #937887

    SQL Server 2005

    In SQL Server 2005 the process of implementing Log Shipping is embedded with the Workgroup, Standard and Enterprise editions of SQL Server. To implement it, right click on a database name and select Properties. On the properties screen there is an option for Transaction Log Shipping. From here you can follow the step by step process to set this up.

    SQL Server 2000

    In SQL Server 2000 this feature is only available in the Enterprise or Developer editions of SQL Server. This does not exist in the Standard or MSDE editions. To enable Log Shipping with this version, this is setup using the Database Maintenance Plan Wizard and selecting "Ship the transaction log to other SQL Servers (log shipping)" at the bottom of the wizard screen.

    MJ

  • February 4, 2009 at 9:00 am

    #938059

    There is another difference

    In SQL Server 2005 you can have one backup job and multiple copy and restore jobs to different servers. ie. One-to-Many (One Backup job --> Many copy,restore (different servers))

    For example I have Prod1, PreProd1, Preprod2 Servers I am going to setup log shipping for one datbase between

    Prod1 --> Preprod1

    Prod1 --> Preprod2

    Here I can have only one backup job and two copy jobs (Preprod1, Preprod2) for and restore jobs (Preprod1, Preprod2).

    Where as in SQL Server 2000 backup job is one-to-one One backup and one copy and one restore.

    Rajesh Kasturi

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

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