Re: Are BAK files secure?

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 07/31/03 

Date: Thu, 31 Jul 2003 12:35:23 -0400

In SQL Server, you can use the WITH PASSWORD option in BACKUP DATABASE. 

-- 
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Jeff McAhren" <mcahren@hotmail.com> wrote in message news:e9UJZ43VDHA.1780@TK2MSFTNGP11.phx.gbl...
Hi,
Are the BAK files that are on our server secure?  So if someone hacked our
network, and couldn't log into our SQL server because it's secure, what
would keep them from stealing the BAK file?
Can you protect or encrypt it?
Thanks,
--
Jeff McAhren
Dallas, Texas

Relevant Pages

  • Are BAK files secure?
    ... Are the BAK files that are on our server secure? ... network, and couldn't log into our SQL server because it's secure, what ...
    (microsoft.public.sqlserver.security)
  • Re: SqlDataReader on Sql 2005
    ... file names from *.BAK files. ... add a named instance it fails. ... Provider, error: 0 - An existing connection was forcibly closed by the ... was that it was a result of an internal error in SQL Server or SqlClient, ...
    (comp.databases.ms-sqlserver)
  • Re: Query
    ... If it's an SQL server backup you can restore it to SQL Server. ... Renaming only works with file copies that just cot a ..BAK extention. ... Do not assume all bak files are just that. ...
    (microsoft.public.windows.server.general)
  • Re: SQL and VBS
    ... If you are copying the backup files (.bak, .trn) then that's another story. ... It is the .bak files so the copy works fine. ... the name of the sql server. ...
    (microsoft.public.scripting.vbscript)
  • Re: Are BAK files secure?
    ... Jasper Smith (SQL Server MVP) ... Are the BAK files that are on our server secure? ... Can you protect or encrypt it? ...
    (microsoft.public.sqlserver.security)
Quantcast