I've got a SQL Server 2008 Cluster that has a 10GB drive used for a particular databases log file. I have a site on SharePoint that had a good few gigabytes of files a document library. Deleting the site sits there for a while in the browser and then gets an unknown error.
The SQL server sits there spinning away and quite rapidly fitting the log file until it runs out of space. I imagine that what is happening is that once the log file gets filled then the transaction aborts which is when SharePoint gives it's unknown error.
I don't have control over the drive size so cannot get the max size of the log increased. I've tried running a shrinkfile on the log and database before hand but it still doesn't make enough space to perform the site delete. I've deleted all the files within the document library (the only data really on the site) and also emptied the recycle bin. This didn't error but the database hasn't reduced in size (even after a shrinkfile) and the site still has the same problem when I try to delete it so I assume the files are still sitting in the database.
I'm now wondering whether I can lower the detail of the log somehow, or temporarily disable the logging on this database just to get this SharePoint operation to complete.
Any advice would be greatly appriciated.