Backup with password

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Backup with password

Backup with password

Rate Topic

Display Mode

Topic Options

Author

Message

river1

Posted Thursday, January 14, 2010 8:28 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

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

Amit Singh

Posted Thursday, January 14, 2010 8:35 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, May 05, 2013 3:41 PM
Points: 110, Visits: 368

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

Post #847601

river1

Posted Thursday, January 14, 2010 8:41 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

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

MANU-J.

Posted Friday, January 15, 2010 2:55 PM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 1,654, Visits: 8,563

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

rspskumar-704119

Posted Sunday, January 17, 2010 1:55 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, February 07, 2013 12:22 AM
Points: 27, Visits: 83

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

Post #848906

GilaMonster

Posted Sunday, January 17, 2010 2:11 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:49 PM
Points: 37,671, Visits: 29,925

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 »

Permissions