July 16, 2002 at 1:29 pm
I have recently switched from 7.0 to SQL 2000. After the switch, I started having problems with my backup jobs. I have read BOL and searched this forum for how backup jobs should be setup. Backups are so important that I would appreciate a second opinion on my jobs. Thanks in advance.
Recovery option: Full
Nightly job at 11pm
Step1 Backup transaction tips to tips_log_dump with noinit
2 Backup transaction tips with truncate_only
3 Backup database tips to tips_dump with init
Every hour during the day
Backup transaction tips to tips_log_dump with noinit
Do I ever need to do a “Backup transaction tips to tips_log_dump with init”? My understanding is the full backup of the database does this.
July 16, 2002 at 5:26 pm
You can do it this way, but I'd make a separate file for each backup. The maintenance plan will do this as well a number of scripts in the library here.
Steve Jones
July 16, 2002 at 9:17 pm
The big question to see if these meet your needs is what is the most you will lose and is this lose acceptable. If so then fine, if not then rethink what you need to have. As for the transaction with the init it depends on the code and the file the logs are being stored in. If it is a seperate file from the database backup then yes you should use init on the first transaction backup after the db backup.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply