Attaching mulitple databases

• Duncan Fraser

  Newbie

  Points: 1

  More actions

  February 10, 2006 at 5:23 am

  #103080

  Hi, I'm pretty new to SQL, not a specific DBA and I'm not sure of the query command to attach multiple databases & logs to a new SQL server.

  I know the "sp_attach_db" command for a single database, however I've got 50 databases that need attaching to this particular server (SQL2000 SP4). I've copied all mdf & ldf files locally.

  Any help greatly appreciated..

  thx,

  Duncan

• Mathew J Kulangara

  SSCommitted

  Points: 1610

  More actions

  February 10, 2006 at 5:27 am

  #620076

  create a temp table with databasenames, and log file locations..etc..

  Use a cursor to use sp_attach_db to attach each on.

  HTH

  ---

  Mathew J Kulangara
  sqladventures.blogspot.com