Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

None of the databases are showing up in the Object Explorer window even when the server has been connected successfully.

It is showing only one database that I have created exactly 1 year back.

How can I get those databases back?

share
    
Do the database files exist on disk? Does you user has permission (use sa to test this)? Do you have backups? –  usr Jul 20 '13 at 13:05
    
For me, this is usually when I have different version of SQL Server installed (2005, 2008, 2012, Express 2008) and I connected to the wrong one. And maybe the service for the one I want isn't even started - so I have to do that first. –  JBrooks Jul 20 '13 at 13:22
    
@karishma Any errors in the log file ? Did you restart the server and then they are not coming back ? –  Kin Jul 20 '13 at 21:22
comments disabled on deleted / locked posts

migration rejected from stackoverflow.com Jul 21 '13 at 14:12

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as unclear what you're asking by marc_s, Aaron Bertrand Jul 21 '13 at 14:12

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

Sounds like you are either connected to the wrong instance / server or someone has removed your permissions on the server. Do you still have rights to the other databases? What rights do you currently have on the server?

share
add comment