A user database listed under System Databases

  • Hello SQL Community,

    I don't even know where to start... well, I know.. google didn't tell me anything, so I come here:

    This is a screenshot from a customer's server, I haven't had the change to go there yet, but as you can see, the is a eReports database listed right along the SYSTEM DATABASES....

    I have no idea how they did that, and I didn't think it's possible, until the screenshot.

    Any ideas?

    Why does this happen? how can it be possible?

    and how do I move it to the user database section

    See link to screenshot below. thanks

    For some reason the link does not work on IE (but who uses IE anyway?)

    So please use Firefox or Chrome

    https://drive.google.com/file/d/0B9ChojDP1w0MMjJleWY1Zm9kaTQ/edit?usp=sharing

    or check out the attachment.

    Thank you

    Miguel Q

  • Is it possible this is their distribution database?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Sounds like a distribution database.

  • distribution database... so you are saying that they can restore a distribution databases under a different name?

    wow... that's a new one.

    I'll check and report back.

    thanks

  • MiguelSQL (3/18/2014)


    distribution database... so you are saying that they can restore a distribution databases under a different name?

    wow... that's a new one.

    I'll check and report back.

    thanks

    You can create a distribution database with a different name too.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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