January 12, 2010 at 3:52 am
I have a database backup.I want nobody can restore it even if he copies the backup to any location/server?Is it possible in SQL Server to restrict the restoration process by any unwanted person and how?
January 12, 2010 at 4:22 am
Look up Transparent Database Encryption (TDE). The whole point of TDE is that a backup cannot be restored to a server unless that server has the correct certificate. Same with attaching.
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
January 12, 2010 at 4:30 am
Its in SQL Server 2008. How to do it in 2000 and 2005?
January 12, 2010 at 4:42 am
No way to ensure that in SQL 2000/2005. Just make sure the backups are secured so that unauthorised people can't get at them.
The post was in the SQl 2008 forum, hence I gave you the SQL 2008 solution.
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
January 12, 2010 at 7:43 am
The only way I could think of is using an external backup compression/encryption software like Arc serve..
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply