dkschill (4/12/2013)

---

So I am exploring PowerShell, and found a DB with .Databases that I can't see in sys.databases.

I ran this following (starting from the Machine level with sqlps):

$i = ls

$i | %{$_.Databases}

It returns a list of all the DBs, but there is one that says that the state is Normal, Standyby.

I don't see it through SSMS, and it isn't in sys.databases.

What could cause this and what should I do about that?