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

  • iLearnSQL

    SSChasing Mays

    Points: 619

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

  • m.r.piatek

    Valued Member

    Points: 72

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

     

  • thisisfutile

    Hall of Fame

    Points: 3527

    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?

  • estanito

    SSC Enthusiast

    Points: 113

    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 4 (of 4 total)

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