Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Posts
    3

    Post Unanswered: Copying SQL Server Database on Client's Machine

    Hello all,

    I have installed a dummy SQL server in my office and created the database..now i want to copy this database on to clients machine but i dont have a remote access to the clients machine..so all i have to do is copy this database on a disk and restore it on clients machine..I dunoo exactly how this procedure works. I need any help ASAp. Thankyou very much.

    Ram

  2. #2
    Join Date
    May 2003
    Location
    Rochester, NY
    Posts
    135

    Re: Copying SQL Server Database on Client's Machine

    Originally posted by sriramkakani
    Hello all,

    I have installed a dummy SQL server in my office and created the database..now i want to copy this database on to clients machine but i dont have a remote access to the clients machine..so all i have to do is copy this database on a disk and restore it on clients machine..I dunoo exactly how this procedure works. I need any help ASAp. Thankyou very much.

    Ram

    You want to readup on attaching and detaching a database...also search this forum or read online help.

  3. #3
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    If your using MS SQL 2000 , and your client is also using MS SQL 2000, you can do it via "Attach/Detach".

    A very simple way. go to enterprise manager, right click on your database, under "All task".select detached database.

    Make sure there are not connections to u'r database when u'r doing a detached, or else u can't do it.

    Also , be sure that your login id has db owner rights for that table, or u'll have trouble attaching back at the client side.


    After detached, you can go to your MS SQL folder and copy your .mdf and .log files into a diskkete. You can even zip it up.

    At the client side, just attached it back.

    Before u do this, create a test database and play around first.
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  4. #4
    Join Date
    Dec 2002
    Posts
    63
    You can also just take a backup of the database and copy the .bak file. then restore. It isnt as fast as detatch and reattach, but it IMO less risky, and easier to do. Read up in BOL on backup and restore procedures. very simple.

Posting Permissions

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