Simple backup DB questions

  • When I copy a database to another server I want to be sure that I have copied all the data in the original database.

    1. I can copy the MDF/LDF files (Sql 7+) to a new server and be sure that all the data in the database and trans logs is copied. Is this correct?

    2. If I dump a database, I presume the dump incorporates all data in the database and any outstanding trans logs. Is this correct?

    3. If I use sp_detachDB, does that grab all data in the database + plus trans logs in the detached DB?



  • 1) Yes, and you use sp_attach_db to connect it to the new server.

    2) Not usually, unless you have read uncommitted set.

    3) It basically is the same as number 1.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply