Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    71

    Unanswered: moving a database from old to new server?

    Hi all. I know that since you know nothing about my database it will
    be a stretch to answer this - but does anyone have a boiler plate
    checklist for moving a database, dts packages, agent jobs, etc...from
    one server to another? Maybe something that just says I should at
    least do x,y,z.

    Also if anyone out there has any hard won experience/advice about
    gotchas when doing this I would love to hear it. We have outgrown a
    server and are installing a new one this week that we need to move
    over to.

    Thanks!

  2. #2
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Well

    If you are migrating complete Server and If you can keep drive letters same with same directory structure. Detach all user databases . Move Ldf and Mdf files to new server in same location, Backup master/msdb on old server

    and restore them to new. Make sure you have Windows accounts moved to new Server too. I don't think you will have any issues at all

Posting Permissions

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