I am facing Low disk space issue in Dev VM’s having PU 40. On checking the disk space it was noted that drive C is full. These VM’s were provisioned ~2 weeks back. Also please note MSQL Logs(H) is full which gave a build/sync error in 1 of the environments in which we were able to open Visual Studio.
It seems due to the above issue we are not able to upgrade the machines to PU 41 as well. I get the preparation failed error. Any pointers wrt resolution of this would be really helpful.
Aren't you using Full recovery model for data bases? And if so, you don't backup logs, do you? Then they'll grow indefinitely. Since it's just a developer environment, the right approach likely is switching to Simple recovery model.
If the recovery model already is Simple, try restarting SQL server and shrink log files.
Hi thanks for your reply with this approach I am able to reduce the folder size for the logs drive however the c drive is still full and its not allowing me to open visual studio or do upgrade. Please note I have removed all custom files/ codes etc from drive c already.
You'll need to analyze what is consuming the space before you can design a solution. There are tools to help you with this analysis, such as SpaceSniffer.
Hi In drive C the most memory is consumed by microsoft sql server this is shown as 2.8gb in file explorer but in 3rd party app it shows up as 45gb can you please suggest how can I clean this space? thanks
Which file or files are you talking about?
this is resolved though getting an error now in LCS:
System.Data.SqlClient.SqlError: Cannot open database "AxDB" requested by the login. The login failed.System.Data.SqlClient.SqlError: Login failed for user 'axdbadmin'.
Please create a new thread and explain in detail what you did before you started getting this error, where are you getting it and so on.