Attach/Detach DB equivalent in SQL Server 7.0

• Ricardo Lopez

  SSC-Addicted

  Points: 491

  More actions

  May 26, 2004 at 4:35 pm

  #84583

  I have a SQL Server 7.0. I wish to move the secondary data files associated with a huge database to another drive with more space. This is pretty straightfoward in SQL Server 2000 by doing detach/attach DB.

  How do I accomplish this in SQL Server 7.0?

• TriggerMe

  SSChampion

  Points: 11752

  More actions

  May 26, 2004 at 6:48 pm

  #507941

  Exactly the same!

  sp_attach_db and sp_detach_db exist in SQL 7.0 as well.

  ---

  Kindest Regards,