SQL Server won't start

  • Hi everyone,

    I've moved the model system database with a wrong filename and stopped the SQL service then tried to start the service and it won't start. please anyone with any information help

  • Kabelo-953105 (6/14/2011)


    Hi everyone,

    I've moved the model system database with a wrong filename and stopped the SQL service then tried to start the service and it won't start. please anyone with any information help

    I'm assuming you used the process noted HERE. If so, can you put the file in the path you specified in your script and then start the instance?

    Can you provide other details if my other assumption is not correct?

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • your assumption is correct, instead executing

    alter database model

    modify file (name = 'modeldev', filename = 'E:\MSSQL\DATA\mode.mdf')

    I executed

    alter database model

    modify file (name = 'modeldev', filename = 'E:\MSSQL\DATA\')

  • Ok, I THINK you can start the instance using the -F switch and run the script to specify the appropriate location. Review the documentation to see how to start the instance in minimal configuration mode.

    http://msdn.microsoft.com/en-us/library/ms180965.aspx

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • Your experience in moving Model is one of the reasons why best practice says do not move master, model or system resource DBs. There are NO integrity or performance reasons to move these databases, so there is no operational reason why these DBs should be moved. All you are doing is to add risk to your installation.

    Also, Microsoft have a history of SPs or CUs failing if these databases are not in their default locations - mostly the SPs and CUs are written OK, but it is a brave person who expects this problem will not happen again.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

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

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