Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup with password Expand / Collapse
Author
Message
Posted Thursday, January 14, 2010 8:28 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, April 07, 2014 10:25 AM
Points: 715, Visits: 1,018
Hi,

Is it possible to make backups in SQL Server 2005 protected my password? or that is only a functionality of SQL Server 2008?

Thank you.
Post #847596
Posted Thursday, January 14, 2010 8:35 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 20, 2014 8:20 AM
Points: 110, Visits: 375
you could try adding a step to you r backup job to compress it with winzip and protect it with password .... just a thought

-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! - desparately trying to fish
Post #847601
Posted Thursday, January 14, 2010 8:41 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, April 07, 2014 10:25 AM
Points: 715, Visits: 1,018
lol , yes , that's possible.

But what i really would like to know is if SQL Server 2005 already as the funcionality of making backups with passwords.

I have looked on the net, but i didn't found any thing.

Thank you
Post #847609
Posted Friday, January 15, 2010 2:55 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 10:30 PM
Points: 1,688, Visits: 8,759
Only possible with t-sql commands.

When you create your backup you can specify a password for the backup file. Then when you want to restore the backup, the password must be specified otherwise the backup fails. One problem with using this feature to protect your backups is that the GUI, both Enterprise Manger and SQL Server Management Studio do not support this option. Also, when you create backups using maintenance plans this is not a supported option either. So the only way to create password protected backups is by using the T-SQL commands for both backup and restore functions.

http://www.mssqltips.com/tip.asp?tip=1108

MJ
Post #848581
Posted Sunday, January 17, 2010 1:55 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 12:17 AM
Points: 28, Visits: 91
If you are looking for high level protection to your backups use TDE[Transparent data encrytion which is more powerfull than passwords]
Post #848906
Posted Sunday, January 17, 2010 2:11 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 41,530, Visits: 34,447
rspskumar-704119 (1/17/2010)
If you are looking for high level protection to your backups use TDE[Transparent data encrytion which is more powerfull than passwords]


Available only in SQL 2008. Not in SQL 2005, which the OP is asking about.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #848908
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse