Welcome to Sign in | Help

Re: CREATE DATABASE - cale absoluta pentru FILENAME

  •  09-12-2008, 1:40 PM

    Re: CREATE DATABASE - cale absoluta pentru FILENAME

    Sintaxa (eronata oarecum) de la CREATE DATABASE din SQL2000 este

    CREATE DATABASE database_name
    [ ON
        [ < filespec > [ ,...n ] ]
        [ , < filegroup > [ ,...n ] ]
    ]
    [ LOG ON { < filespec > [ ,...n ] } ]
    [ COLLATE collation_name ]
    [ FOR LOAD | FOR ATTACH ]

    < filespec > ::=

    [ PRIMARY ]
    (
    [ NAME = logical_file_name , ]
        FILENAME = 'os_file_name'
        [ , SIZE = size ]
        [ , MAXSIZE = { max_size | UNLIMITED } ]
        [ , FILEGROWTH = growth_increment ] ) [ ,...n ]


    Pentru 'os_file_name' BOL se spune clar:

    Is the path and file name used by the operating system when it creates the physical file defined by the <filespec>. The path in os_file_name must specify a directory on an instance of SQL Server. os_file_name cannot specify a directory in a compressed file system.


View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems