#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2008
    Posts
    78
    Rep Power
    11

    IMport into new sql


    Hi all,
    Ive never done MS SQL before and have no idea what I do to get an existing db from one machine (de-commissioning) to another.
    I have done a 'default' install of 2005 express on the new machine and I have a 'Backup' file from the old machine.

    How do I get the db into the new machine?

    Cheers.
  2. #2
  3. Contributing User
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Feb 2007
    Posts
    1,939
    Rep Power
    3122
    Do a "Restore Database".

    Comments on this post

    • Vomster agrees
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2008
    Posts
    78
    Rep Power
    11
    Cheers.
    It all made sense once I installed the Studio Manager. I only had the engine.
    Thanks for the reply.

    Comments on this post

    • jzd agrees : Glad you got it working.

IMN logo majestic logo threadwatch logo seochat tools logo