使用CREATE DATABASE ... FOR ATTACH;
。参见示例H:
的 以下示例将全文目录AdvWksFtCat以及AdventureWorks2008R2数据和日志文件附加在一起。在此示例中,全文目录从其默认位置移动到新位置c:\ myFTCatalogs。数据和日志文件保留在其默认位置。
USE master;
GO
--Detach the AdventureWorks2008R2 database
sp_detach_db AdventureWorks2008R2;
GO
-- Physically move the full text catalog to the new location.
--Attach the AdventureWorks2008R2 database and specify the new location of the full-text catalog.
CREATE DATABASE AdventureWorks2008R2 ON
(FILENAME = 'c:\...\Data\AdventureWorks2008R2_Data.mdf'),
(FILENAME = 'c:\...\Data\AdventureWorks2008R2_log.ldf'),
(FILENAME = 'c:\myFTCatalogs\AdvWksFtCat')
FOR ATTACH;
GO