hi, i have a quick question about the proper way to backup databases. i have a maintenance plan to backup 2 main databases daily at 2 am - i have trans logs to backup every 3 hours daily. also i have the optimization and integrity to run weekly on these 2 databases
i have another maint plan for the master, model, and msdb to backup weekly only - nothing for the trans logs for these databases or optimization and integrity.
is this a correct way to do the backups? i have sql 2000sp4
thanks in advanced