Problem solve Get help with specific problems with your technologies, process and projects.

Restricting access when *.mdf, *.ldf files are copied to another server

I am looking for a solution that would deny access to my database if the files *.mdf and *.ldf were copied onto another server. It seems that when this happens, any server can attach to my database and view the data with the "SA" account.

There isn't anything built into SQL Server for this. You need to practice good security policies on the server....

That means you are only granting admin access to the people who need it. You can controlling access to the file system. You control who can start/stop services. You audit the activities on your server that need to be controlled.


For More Information

This was last published in December 2002

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.