hello guys........
simple syntax for making of file groups in sql
create database test on primary
(NAME=TESTFG, FILENAME='D:\TEST.MDF', SIZE=500MB,MAXSIZE=700, FILEGROWTTH=20)
ALTER DATABASE TEST ON FILEGROUP TEST1
(NAME=TESTPTIMARY, FILENAME='D:\NDF', SIZE=700MB, MAXSIZE=900, FILEGROWTH=20)
simple syntax for making of file groups in sql
create database test on primary
(NAME=TESTFG, FILENAME='D:\TEST.MDF', SIZE=500MB,MAXSIZE=700, FILEGROWTTH=20)
ALTER DATABASE TEST ON FILEGROUP TEST1
(NAME=TESTPTIMARY, FILENAME='D:\NDF', SIZE=700MB, MAXSIZE=900, FILEGROWTH=20)
No comments:
Post a Comment