November 2, 2006 at 3:22 pm
Guys I plan on backing up tlogs from 9-4 basically I created a job that runs every hour and it just appends. These logs will be moved off the server to our storage system at 7PM. I created a backup device for the logs is there some way I can format that backup device lets say at 8PM than I can start fresh the next day?
November 2, 2006 at 4:54 pm
The first backup of the day (9:00 AM?) should use WITH INIT to overwrite the backup sets and start fresh. All other backups during the day should use WITH NOINIT. It probably is a good idea to somehow confirm that the backup files were successfully copied to the storage system before running the initalizing backup.
Greg
Greg
November 2, 2006 at 5:39 pm
Ok I have about 8 critical databases on that box so I will have to create 2 backup jobs for each database. I will do what you've said on the first job to delete and the second job will start the appending for the day.
November 3, 2006 at 8:54 am
It occurred to me that you didn't mention when or how often you do full backups. Are those going to different backup files than the log backups?
Greg
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply