Problem? Log Shipping 2005 > 2005 with database that is in 2000 compatible mode

• Matt Smith-465337

  SSC Journeyman

  Points: 96

  More actions

  September 7, 2007 at 2:39 pm

  #120386

  I have a sql 2005 database log shipping to another sql 2005 database server, and everything seems ok.  The jobs are working, restores are working, etc.

  I have a monitor server set up (sp_help_log_shipping_monitor), and only for this pair of log shipping databases do I see the status "1" for the shipper server.  It says the time_since_last_backup is since I initialized the log shipping configuration, and it says the last_backup_file is NULL.

  Is this an ignorable error, or is there really a problem?  The only thing I can think of is that the particular db is in SQL2000 compatibility mode.

   

  Any ideas?

• Matt Smith-465337

  SSC Journeyman

  Points: 96

  More actions

  September 25, 2007 at 1:14 pm

  #736135

  Thanks for all the help!! I changed to SQL 2005 mode, but I still get "NULL" from the last_backup_file

  Junk!