试一下这个 ALTER DATABASE aaa ADD FILE ( NAME = cyylsystem_Data, FILENAME = 'F:\aaa\DataFiles\cyylsystem_Data.NDF', SIZE = 1MB, MAXSIZE = 1500MB ) TO FILEGROUP UserDataGroup
USE master Goif exists (select * from master.dbo.sysdatabases where name=N'cyylsystem') begin drop database cyylsystem end goEXEC sp_attach_db @dbname = N'pubs', @filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\cyylsystem_Date.mdf', @filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\cyylsystem_log.ldf' GO
呵呵,楼上有个地方抄错了~~~USE master Goif exists (select * from master.dbo.sysdatabases where name=N'cyylsystem') begin drop database cyylsystem end goEXEC sp_attach_db @dbname = N'cyylsystem', @filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\cyylsystem_Date.mdf', @filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\cyylsystem_log.ldf' GO
ALTER DATABASE aaa
ADD FILE
(
NAME = cyylsystem_Data,
FILENAME = 'F:\aaa\DataFiles\cyylsystem_Data.NDF',
SIZE = 1MB,
MAXSIZE = 1500MB
)
TO FILEGROUP UserDataGroup
Goif exists (select * from master.dbo.sysdatabases where name=N'cyylsystem')
begin
drop database cyylsystem
end
goEXEC sp_attach_db @dbname = N'pubs',
@filename1 =
N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\cyylsystem_Date.mdf',
@filename2 =
N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\cyylsystem_log.ldf'
GO
Goif exists (select * from master.dbo.sysdatabases where name=N'cyylsystem')
begin
drop database cyylsystem
end
goEXEC sp_attach_db @dbname = N'cyylsystem',
@filename1 =
N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\cyylsystem_Date.mdf',
@filename2 =
N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\cyylsystem_log.ldf'
GO