Hi,



In SQL Server, anyone can copy the database data file and log file and attach anywhere (a server running SQL server), right?



How to prevent someone from copying data & log files and attach somewhere else.



Is there any way to protect the DB from unauthorized use / misuse?



I mean any one, who has access to windows server can copy the data file and log file and attach in any other place (or) they can copy the backup file and restore in any other place. Is there any way to protect the DB from such activities?



Can we specify password for backup files?



can we set password to access data and log files?



Or any encryption methods available?








---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
MS Sql Server LazyDBA home page