CREATE DATABASE в ALTER DATABASE

CREATE DATABASE Archive 
ON
PRIMARY ( NAME = Arch1,
    FILENAME = 'c:\data\archdat1.mdf'),
FILEGROUP FileStreamGroup1 CONTAINS FILESTREAM( NAME = Arch3,
    FILENAME = 'c:\data\filestream1')
LOG ON  ( NAME = Archlog1,
    FILENAME = 'c:\data\archlog1.ldf')
GO

CREATE DATABASE Archive 
ON
PRIMARY ( 
  NAME = Arch1,
  FILENAME = 'c:\data\archdat1.mdf',
  SIZE = 10MB,
  MAXSIZE = 100MB,
  FILEGROWTH = 1%
),
FILEGROUP FileStreamGroup1 CONTAINS FILESTREAM ( 
  NAME = Arch3,
  FILENAME = 'c:\data\filestream1',
  MAXSIZE = 5000 MB)
 
 
LOG ON  ( NAME = Archlog1,
    FILENAME = 'c:\data\archlog1.ldf',
    SIZE = 5MB,
    MAXSIZE = 25MB,
    FILEGROWTH = 5MB)
GO

--Create and add a FILEGROUP that CONTAINS the FILESTREAM clause to
--the FileStreamPhotoDB database.
ALTER DATABASE FileStreamPhotoDB
ADD FILEGROUP TodaysPhotoShoot
CONTAINS FILESTREAM
GO
 
--Add a file for storing database photos to FILEGROUP 
ALTER DATABASE FileStreamPhotoDB
ADD FILE
(
    NAME= 'PhotoShoot1',
    FILENAME = 'C:\Users\Administrator\Pictures\TodaysPhotoShoot.ndf'
)
TO FILEGROUP TodaysPhotoShoot
GO