June 13, 2002 at 6:51 am
Hi, I wonder if anyone can help with the following.
I don't really know what I'm talking about or where to look. I'm investigating security of backups and wonder if anyone can say why/how secure/implications of each of the following are:
1) RAID & SQL backup with NT backup
2) SQL backup to disk with NT backup
3) Backup exec with SQL agent.
June 13, 2002 at 7:17 am
SQL backups are secured by disk permissions. Same for RAID. Keep the tapes secured - usually are in a locked server room anyway.
Andy
June 13, 2002 at 6:13 pm
Just a note to add, security is only valid if the drive is setup with NTFS and not FAT.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 14, 2002 at 12:41 pm
You'll find some threads here, but I'd backup to disk and then to tape. Use NT permissions (on NTFS drives) to manage the security and lock it down based on groups.
I dislike giving backup operator permissions, even to a backup program.
Steve Jones
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply