create database script

  • Guys,

    Database can be created using script, if create database script is part of app code and the file path for database files are provided what are the other caveats that need to be taken into consideration for the create database script to run on any instance with parameterized file paths?

    Any suggestions and inputs would help.

    Thanks

  • Existence of path. Available disk space. Initial size, growth rate/type. Number of files. Use of filegroups.

    Security (both for creating the database and who can access it afterwards)

    Collation (do you want to inherit the server default or set it yourself? How dependent on collation is your code? Strange things can happen).

    What recovery model to use.

    How much do you want to set, how much do you want the DBA to do, how much information will you provide? E.g. - all very well creating the database, but if there is no DBA, how are the backups going to get handled? Especially if recovery model is set to FULL and no tran log backups are configured.

    Maybe also allow for DBA to create database for application to connect to - some of us don't like it when applications want to create databases themselves - seen too many 3rd party DBs created/configured poorly.



    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare


  • Thanks for your inputs

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply