回复：老O，有没有现成的把SQK2k8的数据库offline然后copy data file的s?

----Step 1 : Detach Database using following
USE [master]
GO
EXEC master.dbo.sp_detach_db @dbname = N'AdventureWorks',
@keepfulltextindexfile = N'true'
GO
----Step 2 : Move Data files and Log files to new location

–—Step 3 : Attach Database using following
USE [master]
GO
CREATE DATABASE [AdventureWorks] ON
( FILENAME = N’C:DataAdventureWorks_Data.mdf’ ),
( FILENAME = N’C:DataAdventureWorks_Log.ldf’ )
FOR ATTACH
GO
IF EXISTS ( SELECT name
FROM master.sys.databases sd
WHERE name = N’AdventureWorks’
AND SUSER_SNAME(sd.owner_sid) = SUSER_SNAME() )
EXEC [AdventureWorks].dbo.sp_changedbowner @loginame=N’sa’,
@map=false
GO

所有跟帖： 

• Detach? Offline是不是更快些？ -天外飞砖- ♀ (0 bytes) () 04/06/2010 postreply 05:23:48