MSSQL 2005 Database encryption through maintenance task

Question

MSSQL 2005 Database encryption through maintenance task

allamiro

Right there with Babe

Points: 717
More actions
July 5, 2011 at 10:25 am

#148254

Is there a way that we can automate this through maintenance task ?

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

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

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

Automate what? Your question has no context.

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

allamiro Right there with Babe Points: 717 More actions · Answer 2

Apologize I created a maintenance task to backup my MSSQL database and I realized that that I need to encrypt it before I put the file to a tape is there a way that I can encrypt it through maintenance tasks on each backup ?

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

SQL 2005 does not have any native backup encryption options. SQL 2008 does (TDE).

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

To encrypt the backup in 2005, you may want to explore a third party utility.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

allamiro Right there with Babe Points: 717 More actions · Answer 5

Thanks yes I see it here on the screen shots from this site

http://www.bradmcgehee.com/2010/01/how-to-use-sql-backup-inside-a-maintenance-plan/[/url]