none
SQL Server 2008 database detaching automatically RRS feed

  • Question

  • Hello All! so I have a weird problem, I have a database and it was working just fine until now, Every time I restart my server, the database seem to disappear. after extensive research I found out that the database just detaches, so I have to attach it again after the server restarts. I can't find a solution to this, has anyone come across it? I did many virus scans, but nothing, so It can't be a virus. I have also tried repairing the sql and that didn't work. I have tried to take this database and added to my test environment, and it seem to work fine, so it is not the database itself, I'm guessing something in the sql server that is corrupt or a virus?
    Wednesday, July 31, 2013 10:28 PM