Backup with password

Question

Backup with password

river1

SSC-Insane

Points: 24309
More actions
January 14, 2010 at 8:28 am

#136550

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.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Amit Singh Ten Centuries Points: 1295 More actions · Answer 1

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 !! :w00t: - desparately trying to fish [/size]

river1 SSC-Insane Points: 24309 More actions · Answer 2

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

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 3

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

rspskumar-704119 SSC Veteran Points: 232 More actions · Answer 4

If you are looking for high level protection to your backups use TDE[Transparent data encrytion which is more powerfull than passwords]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

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, MVP, M.Sc (Comp Sci)
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