Results 1 to 5 of 5

Thread: how can i give a full MS SQL to someone ?

  1. #1
    Join Date
    Jul 2004
    Posts
    106

    how can i give a full MS SQL to someone ?

    I have in my computer a MS SQL 2000 database full of datas and I must give it to someone ... he wants to install it on his computer

    where is the file ?
    how can i do that ?

    thank you

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    1. backup all the databases and give all the backups to that person. [I hope that person know how to restore the backup.]

    or

    2. stop your sql server service. then copy all .mdf,.ndf,.ldf files from your computer to his computer. [I hope that person know how to attach the files.]

  3. #3
    Join Date
    Jul 2004
    Posts
    106
    Enterprise Manager > Tools > backup database > DatabaseName + BackupName + database- complete checked + Destination

    is that all ?

    thank you
    Last edited by qwer; 06-27-2005 at 11:17 AM.

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    That should do it.

  5. #5
    Join Date
    Jul 2004
    Posts
    106
    thanks a lot

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •