durai nagarajan (8/30/2012)
hope i remember u have space crunch issue for backup.differential backup is to prevent data loss from the previous full bakup idealy good if it has been done in between the transaction time.
backup will not delay any work happening at that time.
Thanks for your input Duria! It seems like it's just you who responds to my questions!
No, we don't have space issues!
What I want to say to the manager is that doing a full backup while people are still working is not an issue. SQL Server has the intelligence to backup the data as well as the necessary transactions so that doing a restore brings back the database in a consistent state. The days of offline backups are long gone surely?! Or am I missing something here?
---------------------------------------------------------
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