Post reply

SQL Server 2012 does not come up after service pack upgrade SP4

  • July 27, 2020 at 12:00 am

    #3770425

    Comments posted to this topic are about the item SQL Server 2012 does not come up after service pack upgrade SP4

  • July 27, 2020 at 11:59 am

    #3774923

    Omg who adds a db with logical filename master. Thx for the hint towards TF 902.

     

  • July 27, 2020 at 3:06 pm

    #3775013

    m.r.piatek wrote:

    Omg who adds a db with logical filename master. Thx for the hint towards TF 902.

    Why is it even allowed?

  • July 28, 2020 at 12:17 pm

    #3775332

    I had this issue as well on 3 different production servers, debugging the upgrade script pointed me out that there was a user database with logical name "master".  Further investigation showed us that some inexperienced dbas had executed the database schema on the master database, created a backup and restored it under the what had to be the correct user database name.

    Oh well, things happen.

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

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