The first rule is to restrict access to all servers, both remote and local
physical access.

Unless you do that there is no protection.

-----Original Message-----
From: Bajal Mohamed [mailto:[Email Address Removed] Sunday, January 25, 2004 9:50 PM
To: LazyDBA.com Discussion
Subject: How to protect DB and its files....



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