Account Options

  1. Sign in
The old Google Groups will be going away soon.
Switch to the new Google Groups.
Google Groups Home
« Groups Home
protect DB
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  4 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Ansar Javed  
View profile  
 More options May 2 2002, 7:08 am
Newsgroups: microsoft.public.sqlserver.security
From: "Ansar Javed" <ansar_ja...@yahoo.com>
Date: Thu, 2 May 2002 04:04:07 -0700
Local: Thurs, May 2 2002 7:04 am
Subject: protect DB
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.

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Andrew J. Kelly  
View profile  
 More options May 2 2002, 8:28 am
Newsgroups: microsoft.public.sqlserver.security
From: "Andrew J. Kelly" <ake...@targitinteractive.com>
Date: Thu, 2 May 2002 08:12:00 -0400
Subject: Re: protect DB
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.

--
Andrew J. Kelly   SQL MVP
Targitinteractive, Inc.

"Ansar Javed" <ansar_ja...@yahoo.com> wrote in message

news:906201c1f1c9$143199c0$36ef2ecf@tkmsftngxa12...


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Sue Hoegemeier  
View profile  
 More options May 2 2002, 9:52 am
Newsgroups: microsoft.public.sqlserver.security
From: Sue Hoegemeier <Su...@nomail.please>
Date: Thu, 02 May 2002 07:49:10 -0600
Local: Thurs, May 2 2002 9:49 am
Subject: Re: protect DB
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.

-Sue

On Thu, 2 May 2002 04:04:07 -0700, "Ansar Javed"


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Eric Weinraub[MS]  
View profile  
 More options May 2 2002, 1:31 pm
Newsgroups: microsoft.public.sqlserver.security
From: ericw...@online.microsoft.com (Eric Weinraub[MS])
Date: Thu, 02 May 2002 17:29:21 GMT
Local: Thurs, May 2 2002 1:29 pm
Subject: RE: protect DB
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.

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.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »