Is there a way (encryption or other utility?) to lockdown an SQL database so it can only be copied for backup purposes and can then only be restored to the same server and location? I want to prevent the ability of a SysAdmin or DBO to schema map and copy/modify an SQL database to use with another company or modify themselves. Thanks Roscoe
if the person(s) you are concerned about are sysadmin then no, there will be ways that they could access the database. At the end of the day you need to have trusted staff in positions of responsibility. If you are concerned then prevent them having access to the server but even then, a domain admin will be able to access the database and carry out actions that would give them the schema details that you want to protect.