Master database 'missing'

Question

Master database 'missing'

sqlservercentral 7360

SSC Veteran

Points: 297
More actions
May 14, 2013 at 8:51 am

#272680

Hi folks,
SQL Server 2008R2 - newbie user
Wierd issue of a missing master database - wierd because I would have thought this was a newbie topic but I've found nothing for it. I googled and had a 'decent' look through this forum and only found a bunch of topics on 'how to restore master database'.
I wouldn't have thought I need to restore the master database because my SSMS works fine and I can query the master database. I can also see it in the drop down list of available databases in the Query Designer toolbar.
The problem is just that I can't see it in the list of databases. I can see all the other databases I've created, and I can see the master database in the DATA folder. But not in the SSMS.
I'm pretty sure I was able to see it a few weeks ago when I first loaded SQL Server 2008R2. But its not there now.
Any useful comments/suggestions please?
Cheers,
Chris

Viewing 8 posts - 1 through 7 (of 7 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

It's in the system database folder under databases, along with model, msdb and tempDB

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

adb2303 SSCertifiable Points: 7588 More actions · Answer 2

I take it you've looked in the "system databases" folder. Can you see msdb, tempdb and model?

sqlservercentral 7360 SSC Veteran Points: 297 More actions · Answer 3

Many thanks for the prompt replies!

No luck so far - can't see any system databases.

Three extra bits of information that I should have added first time:

1) this is the evaluation 180 day product.

2) a jpeg of what I'm looking at (attached)

Cheers,

Chris

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Tools -> Options. Environment -> General

Your master database is not missing, if it was SQL wouldn't even start.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

sqlservercentral 7360 SSC Veteran Points: 297 More actions · Answer 5

Ahh...that did the trick Gail 🙂

I vaguely remember now readng some tutorial telling me to check that box, but I couldn't find it again today and didnt come across anyone else looking for similar (I guess my search parameters must have been faulty).

Thanks again for the help (and to adb2303) - spent way too long trying to fix that so appreciate you putting it right for me!

Cheers,

Chris

Dird SSCertifiable Points: 5081 More actions · Answer 6

Dird

SSCertifiable

Points: 5081

May 14, 2013 at 1:51 pm

#1615181

Haha I thought it would be that issue.

Dird

Dird

selvacks Grasshopper Points: 19 More actions · Answer 7

Hey,

For me also same issue , system databases is missing . But its working fine , data and log files also in directory .