Post reply

How to share a database with another user

  • August 12, 2008 at 7:33 am

    #192259

    I needed to provide a copy of a database to someone. We don't have access to each other's network and this is a one-time deal where I need to get the database to him so he can add it to his database server. We are both using sql server 2005.

    On my first pass, I simply detached the database and sent him the files. When he tried to attach them, sql server 2005 said no-can-do "the files are locked".

    What is a better technique?

    Thanks

    Mike

    Mike Kleiman

  • August 12, 2008 at 7:39 am

    #856690

    Hi,

    I would backup the database and give it to the other person he can restore the backup and that should do it.

  • August 12, 2008 at 7:41 am

    #856692

    till you do not have network conn is very poor system... otherwise I do not have any idea how to do sharing without network conn!!!

    :hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

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

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