Post reply

Creating two databases at the same time, strange behavior

  • May 30, 2013 at 2:04 am

    #293936

    Situation:

    Create a database in SQL Server 2008 R2, using the wizard. (with a big logfile so it takes some time)

    When the database is being created, start the wizard again to create another database.

    Don't click OK but look at the options. The recovery model is SIMPLE and the Compatibility level is 2005!!

    Has anybody seen this behavior also and is there an explanation for this behavior?

    thanks,

    Robbert

  • May 30, 2013 at 2:45 am

    #1619588

    Has the recovery model of the "model" db changed? New dbs get their recovery model initial setting from the model db. Could this have changed in between creating this new dbs?

    [font="Times New Roman"]There's no kill switch on awesome![/font]

  • May 30, 2013 at 3:00 am

    #1619596

    No changes to the model database, the model database has the correct options (FULL and 100 (SQL Server 2008))

    This only happens when you create 2 databases at the same time.

  • May 30, 2013 at 5:46 am

    #1619650

    any chance there is a DDL server trigger or extended event doing it?

    i've got examples of adding roles to a database automatically if they do not exist,whenever the a database is created or restored, so it would be easy to also change the compatibility level at the same time.

    most probably place to start is select * from sys.server_triggers if that is a possibility.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 30, 2013 at 6:22 am

    #1619668

    If there were triggers active, this should also happen when you create 1 database.

    This problem only shows up when creating 2 at the same time.

Viewing 5 posts - 1 through 4 (of 4 total)

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