Post reply

Protecting MDF files

  • June 25, 2007 at 3:19 am

    #177201

    Hi forum,

    I have a database in a SQL Server 2005 Express installation. How can I avoid

    that somebody copies the MDF file and attaches it to another computer?

    I remember in Access, you could at least put a password to access the

    database... can I do something like this in SQL Server?

    Thanks!!

    Arnau.

  • June 25, 2007 at 3:41 am

    #714878

    You cannot copy an online file; in order to move database files you have to detach it first. Check Securing Data and Log Files in BOL.

  • June 25, 2007 at 4:10 am

    #714883

    But somebody could stop the service, and the file would become offline, so it could be copied.

    I want to avoid that the file can be attached again...

  • June 25, 2007 at 5:43 am

    #714888

    I hope you should have placed the data files and log files under a NTFS volume. give privilege to the users only who need to read/write the database. for others revoke the privilege from those directories.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply