Back up Strategy 1

[rmiller11]

Currently I am doing two backups a day on two different databases to file. Night time and Noon. They are then backed up to tape which runs nightly. I would like to get more backups per day so am considering the differential with which I would have two different for each database since I have two full back ups per day.

They databases are not very big, 1 GB and 6 GB. The 6GB takes 5 minutes to do a full back up.

I would like one of the differentials to append to file from 1:00pm to 6:00 Pm every hour. The next day, how do I get it to over write the preceeding days file and append to the file again after I do the full mid day backup?

Also, when I do a differential, does it reset the transaction log like with a full backup?

 

[SQLBill]

when I do a differential, does it reset the transaction log like with a full backup

No.

how do I get it to over write the preceeding days file and append to the file again after I do the full mid day backup?


I would create TWO differential backup jobs. On the first, include the WITH INIT command. That will cause it to overwrite the file. On the second job, use WITH NOINIT. That will cause the second job to append to the first.

-SQLBill