Updating a production database with back up of development database

Discussion in 'Databases' started by forumposters, May 8, 2007.

0
  1. #1
    Can someone please point me to step by step instructions on how this is done?
     
    forumposters, May 8, 2007 IP
  2. forumposters

    forumposters Peon

    Messages:
    270
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #2
    By the way, I'm asking about SQL Server 2005.
     
    forumposters, May 9, 2007 IP
  3. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #3
    gibex, May 14, 2007 IP
  4. Clark Kent

    Clark Kent Guest

    Messages:
    122
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Stop development sql server.
    Copy your database files (mdf and ldf) to production sql servers database directory.
    Open Enterprise manager and attach your database. you can use also sp_attachdb stored procedure but enterprise manager GUI is easyier.
    Don't forget to start your development server :)
     
    Clark Kent, May 16, 2007 IP