snootalope
IS-IT--Management
Hello
My knowledge of SQL and all is fairly limited so hopefully someone can lend me some advice here..
We're using CA ARCserve 11.5 SP3 with the SQL agent to backup our SQL 2005 DB. The backup says it's successful and all, but I'm a bit nervous that it's not really doing what it's supposed to do (or not configured correctly).
What concerns me:
We've got a maintenance plan that runs hourly and backs up the transaction log to a local disk/file. I've got it set to "append" to the file it backs up to. That works fine, but after a full backup runs each night for the DB, the transaction log backup file doesn't clear, it just keeps building in size. I would think that after a full backup that the transaction log would reset itself to a clean state since the last backup. Is that correct, or am I missing something there? Do I not need to do the append, and instead just do an overwrite?
My knowledge of SQL and all is fairly limited so hopefully someone can lend me some advice here..
We're using CA ARCserve 11.5 SP3 with the SQL agent to backup our SQL 2005 DB. The backup says it's successful and all, but I'm a bit nervous that it's not really doing what it's supposed to do (or not configured correctly).
What concerns me:
We've got a maintenance plan that runs hourly and backs up the transaction log to a local disk/file. I've got it set to "append" to the file it backs up to. That works fine, but after a full backup runs each night for the DB, the transaction log backup file doesn't clear, it just keeps building in size. I would think that after a full backup that the transaction log would reset itself to a clean state since the last backup. Is that correct, or am I missing something there? Do I not need to do the append, and instead just do an overwrite?