I’m doing exercises to practice for a test I have this week and what I’m currently doing is DDL exercises (create and modify databases, add files to it, modify their propperties etc). But I reached the third exercises and says: create the database ‘datos3’ with the following options:

data file 1: name = datos3, size = 15mb

data file 2: name = datos3_secundario, size = 10mb, maxsize = 45mb, filegrowth = 1mb

log file: name = datos3_log, size = 5mb, maxsize = unlimited, filegrowth = 10%

The problem is is that it underlines ‘name’ for datos3_secundario and datos3_log so I can’t execute the query and I have no Idea what could I be doing wrong. I will also add the previous exercises (that I could do normally)

So far I have this:

--Crear la base de datos 'datos1', con las opciones por defecto.

CREATE DATABASE datos1;

--Crear la base de datos 'datos2' con las siguientes opciones

CREATE DATABASE datos2
ON PRIMARY
    (NAME = datos2,
      FILENAME = N'C:examendatosdatos2_data.mdf',
          SIZE = 5MB,
          MAXSIZE = 50MB,
          FILEGROWTH = 10%)

LOG ON
    ( NAME = datos2_log,
      FILENAME = N'C:examendatosdatos2_log.ldf',
          SIZE = 10MB,
          MAXSIZE = unlimited,
          FILEGROWTH = 1MB)
GO

--Crear la base de datos 'datos3' con las siguientes opciones

CREATE DATABASE datos3
ON PRIMARY
    (NAME = datos3,
      FILENAME = N'C:examendatosdatos3.mdf',
          SIZE = 15MB)

    ( NAME = datos3_secundario,
    FILENAME = N'C:examendatosdatos3_secundario.mdf',
    SIZE = 10MB,
    MAXSIZE = 45MB,
    FILEGROWTH = 1MB)

LOG ON
    ( NAME = datos3_log,
      FILENAME = N'C:examendatosdatos3_log.ldf',
          SIZE = 5MB,
          MAXSIZE = unlimited,
          FILEGROWTH = 10%)