Re: How To Protect Backup being restoted in any others from other serv

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 10:42:13 +0200

Thanks for catching that Peter. :-)

And I completely forgot about the 3:rd party utils which can encrypt along with compression on the fly. I
guess I should look into your tool, some rainy day. :-) 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter Yeoh" <nospam@nospam.com> wrote in message news:ONojl64TEHA.556@tk2msftngp13.phx.gbl...
> Tibor meant 'Note that this isn't designed to be strong', instead of 'Note
> that this isn't designed to be string'.
>
> Peter Yeoh
> http://www.yohz.com
> Need smaller SQL2K backups?  Try MiniSQLBackup
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
> message news:%23gb5Q44TEHA.1764@TK2MSFTNGP10.phx.gbl...
> > The only "security" feature provided by SQL Server is password. Note that
> this isn't designed to be string, as
> > it doesn't encrypt the data. Use other means to protect the file (physical
> security, network security, EFS
> > etc).
> >
> > -- 
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Narayan Saran" <Narayan Saran@discussions.microsoft.com> wrote in message
> > news:22C62529-CF06-42CC-8BF0-426957CB9F69@microsoft.com...
> > >     We have a Database backup taken in SQLServer 2000. How To protect
> this backup is getting restored in any
> > other servers (in case Database backup stolen from us). One way is we can
> give passwords to the backup. is
> > there any other ways, like in Access Database it has MDW files linked to
> each Database and these databases can
> > be opened only if the MDW is available and correct password is supplied to
> the same
> > >
> > > Help Us.
> > >
> > > Thanking You
> >
> >
>
>

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.server)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.programming)
  • Re: Storing Connection String
    ... you can encrypt the traffic to the SQL Server. ... Hitchhiker's Guide to Visual Studio and SQL Server ... My idea is to have just one database user whose username and password ... Which means that if an user get hold of connection string ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: "Best Practices" way to distribute MSDE
    ... > Restore a users's selected backup. ... for dayly house-keeping I do usually provide scripted job for database ... that file copy operation (not SQL Server backup!) can be performed.. ... my personala advice is to perform dayly house-keeping actions ...
    (microsoft.public.sqlserver.msde)