Seeing Multiply Lines in the log of a completed job

• 
  Hi Chris,
  
  Would it be possible to send a screen shot to my email id priya.sinha@red-gate.com please?
  
  Thanks,
  Priya

  priyasinha March 18, 2009 10:42

  - 0 +
• 
  What ever was the cause of this?

  meklembl April 02, 2009 08:00

  - 0 +
• 
  I was told it was a cache problem that should be fixed in version 6.
  
  Chris

  ChrisAVWood April 02, 2009 10:57

  - 0 +
• 
  I continue to see backups and restores from 2008 in my Activity History frame. I have my delete option set to 60 days and when I run the query below on the affected server I do not see any dates from 2008. Which means that the data from the Activity History window does not refresh from the database, even when you hit refresh.
  
  So this brings two things to the table. First, I would like the Refresh to do a refresh of the Activity History window. Second, I would like the Date column to at least, optionally, show the year.

  meklembl June 10, 2009 09:09

  - 0 +
• 
  I forgot to include the query in the prior message.
  
  master..sqbdata
  'SELECT *
  FROM backuphistory
  WHERE id > 0
  AND backup_start > ''1901-01-01 00:00:00''
  ORDER BY backup_type, backup_start '

  meklembl June 10, 2009 09:15

  - 0 +
• 
  Larry,
  
  You are looking in msdb with your query. Outside of SQL Backup are you trimming the entries in msdb using SQL Server Agent properties/History? If you aren' then this may explain why your query in msdb is returning entries.
  
  Chris

  ChrisAVWood June 11, 2009 11:28

  - 0 +

Add comment

Please sign in to leave a comment.