moving database from one server to another RRS feed

  • Question

  • Which is the best option used to move database from one server to another serve on same network? a) Import - Export b)Backup-Restore c)Detach-Attach Why?
    Tuesday, March 16, 2010 11:06 AM


  • Hello psingla,

    The answer depends on the affords.

    C) Is the fastest way, but during you move it, the database isn't available.
    B) Takes some time, but during it you can allow readonly access to the database on the old server.
    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    Tuesday, March 16, 2010 11:48 AM