magritton
6/16/2014 - 12:22 AM

This detaches a database from a server instance. The true is for skipping the checking feature

This detaches a database from a server instance. The true is for skipping the checking feature

EXEC sp_detach_db 'OPW_PWA_DB', 'true';
EXEC sp_detach_db 'Profile DB', 'true';
EXEC sp_detach_db 'PWA_Archive_FMS_2010', 'true';
EXEC sp_detach_db 'PWA_Draft_FMS_2010', 'true';
EXEC sp_detach_db 'PWA_FMS', 'true';
EXEC sp_detach_db 'PWA_Published_FMS_2010', 'true';
EXEC sp_detach_db 'PWA_Reporting_FMS_2010', 'true';
EXEC sp_detach_db 'SharePoint_AdminContent_272130ef-55f0-43f7-a484-53a69ff1fb72', 'true';
EXEC sp_detach_db 'SharePoint_Config', 'true';
EXEC sp_detach_db 'Social DB', 'true';
EXEC sp_detach_db 'StateService_172b621a5f794da7a9e6b21c6962c75d', 'true';
EXEC sp_detach_db 'Sync DB', 'true';
EXEC sp_detach_db 'WSS_Content_26c2fa03-cc73-4601-800a-9fd2e480ac55', 'true';
EXEC sp_detach_db 'WSS_Content_383fd1ce-ae66-41f5-8104-672348e9f33c', 'true';
EXEC sp_detach_db 'WSS_Content_38943c58-e329-4228-b6d9-1d9da32392f0', 'true';
EXEC sp_detach_db 'WSS_Content_a021fc1d-b44c-4075-894e-66e2f3ca3223', 'true';
EXEC sp_detach_db 'WSS_Content_FMS_2010', 'true';
EXEC sp_detach_db 'WSS_Content_mySite', 'true';
EXEC sp_detach_db 'WSS_Content_OPW_Project', 'true';