John Mitchell-245523 (8/30/2012)
Is there any reason you can't schedule your full backup as well?
Hi John,
Yes, you are right. There is no reason for this job to be run manually.
It's correct to say that you can backup with users on the system. However, given that your database isn't in full recovery mode, you want to make sure you capture enough transactions to make your full and differential backups as up-to-date as possible. The best way of doing that is by waiting until the working day is over.... assuming, that is, that you have such well-defined periods of activity.
I see what you mean. In that case I will schdule the FULL BACKUP job to run SATURDAY/SUNDAY instead.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn