Detaching and Attaching database

• ALVIN R GARCIA

  SSC Enthusiast

  Points: 175

  More actions

  April 23, 2004 at 2:38 pm

  #85192

  The feature to detach and attach the database is gray out (not available).  How can you perform this task if these features are not available to use in SQL Server enterprise Manager

• April 26, 2004 at 8:00 am

  This was removed by the editor as SPAM

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  April 26, 2004 at 8:30 am

  #504235

  In Query Analyzer you could run:

  sp_detach_db and sp_attach_db. Refer to the BOL for more information.

  Also, do you have the appropriate privileges to detach/attach a database?

  -SQLBill

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  April 26, 2004 at 8:32 am

  #504236

  Forgot one thing....is this a replicated database? If so, BOL says it must be unpublished for sp_detach_db to work.

  As for privileges, you must be a member of sysadmin on the database.

  -SQLBill