SQL Server 2000 - ответы
Количество вопросов - 720
CREATE DATABASE demo ON PRIMARY ( NAME = demo1, FILENAME = 'd:\data\demo_dat1.mdf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20),( NAME = demo2, FILENAME = 'e:\data\demo_dat2.ndf', SIZE = 200MB, MAXSIZE = 200, FILEGROWTH = 20)LOG ON ( NAME = demolog1, FILENAME = 'l:\data\demo_log1.ldf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20)GOДанный сценарий SQL выполняет действия:
CREATE DATABASE APPDATA PRIMARY ( NAME = APPDATA1, FILENAME = 'C:\data\demo_APPDATA1.mdf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20),FILEGROUP APPDATAGROUP( NAME = APPDATA2, FILENAME = 'C:\data\demo_APPDATA2.ndf', SIZE = 200MB, MAXSIZE = 200, FILEGROWTH = 20),( NAME = APPDATA3, FILENAME = 'C:\data\demo_APPDATA3.ndf', SIZE = 200MB, MAXSIZE = 200, FILEGROWTH = 20) LOG ON ( NAME = demolog1, FILENAME = 'C:\data\demo_APPDATALOG.ldf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20)GOДанный сценарий SQL выполняет действия:
CREATE DATABASE APPDATA PRIMARY ( NAME = APPDATA1, FILENAME = 'C:\data\demo_APPDATA1.mdf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20),FILEGROUP APPDATAGROUP( NAME = APPDATA2, FILENAME = 'C:\data\demo_APPDATA2.ndf', SIZE = 200MB, MAXSIZE = 200, FILEGROWTH = 20),( NAME = APPDATA3, FILENAME = 'C:\data\demo_APPDATA3.ndf', SIZE = 200MB, MAXSIZE = 200, FILEGROWTH = 20) LOG ON ( NAME = demolog1, FILENAME = 'C:\data\demo_APPDATALOG.ldf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20)GOДанный сценарий SQL выполняет действия:
CREATE DATABASE demo ON PRIMARY ( NAME = demo1, FILENAME = 'd:\data\demo_dat1.mdf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20),( NAME = demo2, FILENAME = 'e:\data\demo_dat2.ndf', SIZE = 200MB, MAXSIZE = 200, FILEGROWTH = 20),LOG ON ( NAME = demolog1, FILENAME = 'l:\data\demo_log1.ldf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20)GOДанный сценарий SQL выполняет действия:
CREATE DATABASE demo ON PRIMARY ( NAME = demo1, FILENAME = 'd:\data\demo_dat1.mdf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20),( NAME = demo2, FILENAME = 'e:\data\demo_dat2.ndf', SIZE = 200MB, MAXSIZE = 200, FILEGROWTH = 20),LOG ON ( NAME = demolog1, FILENAME = 'l:\data\demo_log1.ldf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20)GOДанный сценарий SQL выполняет действия:
CREATE DATABASE APPDATA PRIMARY ( NAME = APPDATA1, FILENAME = 'C:\data\demo_APPDATA1.mdf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20),FILEGROUP APPDATAGROUP( NAME = APPDATA2, FILENAME = 'C:\data\demo_APPDATA2.ndf', SIZE = 200MB, MAXSIZE = 200, FILEGROWTH = 20),( NAME = APPDATA3, FILENAME = 'C:\data\demo_APPDATA3.ndf', SIZE = 200MB, MAXSIZE = 200, FILEGROWTH = 20) LOG ON ( NAME = demolog1, FILENAME = 'C:\data\demo_APPDATALOG.ldf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20)GOДанный сценарий SQL выполняет действия: