Jump to content

Andeavour

Members
  • Content count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Andeavour

  • Rank
    Occasional Forum Poster
  1. I've got a big problem with the 6.5 SQL Server agent. It's supposed to be doing differential backups of a database, but it's actually backing the whole database up every time. The setup is Server A runs transactional Replication to Server B, and Server B runs a Dantz SQL agent to back up the database once a day (Belt and Braces effect). The agent is configured for differential backups, but it just backs up the whole database file every time, and since this is now a 28 Gigabyte database this is beginning to be a costly exercise in DVDs. Is there a problem with the SQL Agent on 6.5? or can anyone think of a reason why it should refuse to do differential backups even though that is what the script tells it to do?
×