To create an SQL database manually, run the following SQL script:
CREATE DATABASE [<database name>]
ON PRIMARY
(
NAME = [<name of database>_
<logical name of the primary data file> ],
FILENAME = '<full path to the primary data file>'
),
FILEGROUP [<name of database>_BACKUP_DATA_FILE_GROUP]
(
NAME = [<name of database>_BACKUP_DATA_FILE_GROUP],
FILENAME = 'full path to the secondary data file'
)
To manage the database that has been created manually, you must grant the relevant access rights to the account intended for database preparation.
Page top