SQL Server Performance

Log Shipping Question

Discussion in 'SQL Server 2008 General DBA Questions' started by sql_jr, Sep 7, 2010.

  1. sql_jr New Member

    I have a question. I know, that you can log ship upstream from SQL Server 2000 to SQL Server 2008 but you cannot Log Ship downstream from SQL Server 2008 to SQL Server 2000. Is this true as well if the database on SQL Server 2008 is in 80 (2000) compatibility mode? Please answer. TIA
    sql_jr, Sep 7, 2010
    #2

  2. ashish287 New Member

    I dont think it will make any difference by putting compatibility mode to 2000 as log shipping need to be configured at server level.
    ashish287, Sep 7, 2010
    #3

  3. satya Moderator

    Yes it is not possible to downstream even though if you keep the DB compatibility to 80, because certain system catalogs are upgraded to SQL 2008 mode which are not supported/recognised in SQL 2000 version.
    satya, Sep 20, 2010
    #4

Share This Page