Backup with password

  • 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.

  • 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]

  • 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

  • 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

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

  • 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

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

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