file linking or connect datafile to datafile group

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

file linking or connect datafile to datafile group

Author

Topic

johnny1walker
Starting Member

17 Posts

Posted - 2012-03-09 : 14:49:48

hi,,this forum best.

I have a problem
how i can do;

connect file = test3 data FILE to testgroup2 FILEGROUP
and this
connect file = test4 data FILE to testgroup2 FILEGROUP

LITTLE DETAIL ==>
------------------

ALTER DATABASE test
ADD FILE
(NAME = test3,
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test3.ndf',
SIZE = 5MB, MAXSIZE=100MB, FILEGROWTH = 5MB)
GO

---------------------

ALTER DATABASE test
ADD FILE
(NAME = test4,
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test4.ndf',
SIZE = 5MB, MAXSIZE=100MB, FILEGROWTH = 5MB)
GO

----------------------

ALTER DATABASE test
ADD FILEGROUP testgrup2
GO

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources