Having an issue with SQL creating log dumps on my SBS 2011 box. This seemed to start all of assunden and nothing has been done that should have caused it. It could have been an update but I do not recall any update getting installed around when this started.
Basically I have 400GB's asside for my SBS VM and the SBS without the log dumps takes up 120GB's, within 2 days of doing nothing the HDD will be full due to the folder in the image bellow. I am running CCleaner over the folder on a daily basis to keep it functioning, some files cannot be deleted due to being access by a process.
The only error in the event log that seems to have any relation to the issue and one of very few errors in the event log at all is in the image bellow.
The only thing that I get pointed at when doing my research on this is SQL Maintenance of which I have never ever had to do or seen done on an SBS box that is effectively default.
It gets used for exchange and basically nothing else, not files, print, sharepoint, sql (other than built-in SBS usage) or any of that gets used or has had settings changed from a default install.
I am trying to connect to the SQL server with management studio (Server: (local) - Type: Database Engine - Auth: Windows) to look at and run maintenance but all I get is the error bellow.
Now I am not sure if I am triyng to connect incorrectly and if maintenance will do anything. I am a complete SQL novice so any imput will be very helpful.