Title: MSSQL DB Browser not coming up
Tags: sql-server;database
Question: I have couple of database on SQL server which were working fine. Now I am no longer able to explore those. What can be the reason?
Also i am getting below error while trying to turn database on
"File activation failure. The physical file name "D:\Microsoft SQL Server\MSSQL10_50.MSSQLSER\DATA\DB_NAME_log.ldf" may be incorrect.
The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure."
Comment: No error message (check your event log)? What is *now* - i.e. since when, and what has changed in the meantime ('nothing' is not an acceptable answer, because stuff constantly changes)? Are you administering all this yourself; if not - did you check with your IT people? What SQL server version are we talking about? *It no longer works* is a question no one can answer.

Comment: Hi @JanDoggen I just spoke to IT people. They have removed .log files of these database. I am not sure if that is causing an issue.

Comment: See the following: http://stackoverflow.com/questions/14248260/how-to-attach-mdf-with-no-log-file

Comment: have the IT people removed the ldf file ? if so than fire them all...There is a method to attach an mdf file without an ldf I just cannot remeber how its called right now



{'source': 'StackExchangeDataset', 'subset': 'stackoverflow.com', 'metadata': {'AnswerCount': 0, 'CommentCount': 4, 'ContentLicense': 'CC BY-SA 3.0', 'CreationDate': '2016:00:08/05/16', 'FavoriteCount': None, 'PostTypeId': 1, 'Tags': '<sql-server><database>', 'Title': 'MSSQL DB Browser not coming up', 'ViewCount': 54, 'id': 38783848, 'user_AboutMe': None, 'user_AccountId': 6734497.0, 'user_DisplayName': 'Hemal', 'user_Reputation': 114.0, 'user_Views': 27.0, 'user_id': 5189737.0}}