Simple backup DB questions

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  March 19, 2002 at 5:58 pm

  #104884

  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?

  TIA,

  Bill

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 19, 2002 at 6:45 pm

  #425668

  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)