Last week, we had a database become unavailable due to log file corruption. The ASP.NET MVC web application displayed fatal error 9001 when the database was accessed. The database was only up for approximately 2 weeks with no activity and there was only 2 MB of data in the database. Tech support was able to get it back up quickly using DBCC (kudos!). However, we are a bit concerned that this happened at all. We have a few questions... - Is there a standard process that ensures the log files do not become corrupt (ie, scheduling DBCC to run on an ongoing basis)? - Should we expect to have to do this type of maintenance on our databases? - What does DiscountASP do from a database administration perspective? - Are customer databases being backed up? Thanks in advance!
In general, log files rarely gets corrupted during maintenance. I talked to our DBA and this is first time we say it. No. If this becomes a ongoing issue, we'll open a ticket with Microsoft. Yes. On a nightly basis.
