Ask the Expert

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.

    Requires Free Membership to View

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 first published in December 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: