none
preventing attachment of database

    Question

  • how do i prevent unauthorized attachment of my database in another instance of sql server
    Friday, April 19, 2013 10:42 PM

Answers

All replies

  • Hello,

    When you are using the Enterprise Edition, then you can use TDE = Transparent Data Encryption to protect your database file. Otherwise you don't have any further Options.


    Olaf Helper

    Blog Xing

    Saturday, April 20, 2013 2:27 AM
  • hello olaf,

    thank you

     i am using sql server 2005 and i dont know if your solution will work but i will try it.

    In case it doesn't which type of sql server would be best suited to solving this problem

    thank you very much

    Saturday, April 20, 2013 6:48 PM
  • i am using sql server 2005 and i dont know if your solution will work but i will try it.


    TDE was first introduce in SQL Server 2008 and is only available in Enterprise Edition. And I don't know any other Option.

    Olaf Helper

    Blog Xing

    Sunday, April 21, 2013 5:30 AM