deleting database
-
Friday, March 08, 2013 7:52 AMI have had people delete my databases from the folder in the server. How can I avoid that? I tried encrypting the database but no good – it deletes.
All Replies
-
Friday, March 08, 2013 9:38 AMModerator
I have had people delete my databases from the folder in the server. How can I avoid that? I tried encrypting the database but no good – it deletes.
Not enough information ! Which databse are you referring here ?
If the Database in question is MS SQL, AFAIK, Database cannot be deleted while SQL server service is up and running.
In general, if you would like to restrict users from deleting files, keep files in a directory/folder and implement file access control using NTFS permissions. Make sure your user ID has full access and grant limited (Read Only) or no permissions to other users.
Regards, Santosh
I do not represent the organisation I work for, all the opinions expressed here are my own.
This posting is provided "AS IS" with no warranties or guarantees and confers no rights.
Whenever you see a helpful reply, click onVote As Helpful & click on
Mark As Answer if a post answers your question.
- Proposed As Answer by Nick Gu - MSFTMicrosoft Contingent Staff, Moderator Monday, March 11, 2013 5:08 AM
- Marked As Answer by Nick Gu - MSFTMicrosoft Contingent Staff, Moderator Monday, March 18, 2013 2:18 AM
-
Monday, March 11, 2013 10:35 AM
Hello,
if you have the need to prevent other users from deleting your data DON'T give them permissions to the folder, it's that easy.
Best regards
Meinolf Weber
MVP, MCP, MCTS
Microsoft MVP - Directory Services
My Blog: http://msmvps.com/blogs/mweber/Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.
.png)
