Few times I faced this problem with both versions and The scenario is like this:
am working on the enterprise designer then for some reason if the computer hangs or another issue happens and then have to restart the computer then when I try to open the designer it shows database not available. Then when I open Sql Server management studio then I find that the status of the database is Pending Recovery.
Then I have to find a way to bring it back to active. so, I have to set the status to offline and then make it online. only then the database is again active.
Why does this happen. any way to avoid this.