Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
protect DB
0 views
Skip to first unread message
Ansar Javed
May 2, 2002, 7:04:07 AM5/2/02
to
How can i protect my sql server backup file. I mean nobody
will restore it except me. i mean is there any protection
possibility to protect my backup.dat file from others.
will restore it except me. i mean is there any protection
possibility to protect my backup.dat file from others.
Andrew J. Kelly
May 2, 2002, 8:12:00 AM5/2/02
to
You can put it in a directory where only you have permissions to get at the
file. But other than that is someone has sa rights then they can pretty
much do as they please. The key is to not let individuals who shouldn't be
there get there.
file. But other than that is someone has sa rights then they can pretty
much do as they please. The key is to not let individuals who shouldn't be
there get there.
--
Andrew J. Kelly SQL MVP
Targitinteractive, Inc.
"Ansar Javed" <ansar...@yahoo.com> wrote in message
news:906201c1f1c9$143199c0$36ef2ecf@tkmsftngxa12...
Sue Hoegemeier
May 2, 2002, 9:49:10 AM5/2/02
to
In addition to Andrew's response of file/directory
permissions, if you are on SQL Server 2000 you can password
protect your backups. Someone would need the password to
restore the backup.
permissions, if you are on SQL Server 2000 you can password
protect your backups. Someone would need the password to
restore the backup.
-Sue
Eric Weinraub[MS]
May 2, 2002, 1:29:21 PM5/2/02
to
At the sql level, you can restrict the use of the backup command. Assuming
that this is on a machine that has NTFS permissions, you can remove read
permissions on the file to everyone but yourself.
that this is on a machine that has NTFS permissions, you can remove read
permissions on the file to everyone but yourself.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
0 new messages