homebrew01 (8/14/2013)
Is 3 hour data loss acceptable for the business ? I prefer log backups every 15 or 20 minutes.I run a server side trace 24/7 on my production server so that I can go back in time to troubleshoot problems or see what was running at a particular time. There are 3rd party tools such as Idera's Compliance Manager that can be set up to audit SQL activity.
I am not asked for Server side trace.. just asked me to take backup. but will it help.. will that provide me data about who did what & what ahppened :w00t:
************************************
Every Dog has a Tail !!!!! :-D