#Local disk c is full free

Old Tempdb datafiles are still sitting there. An example would be where you have moved Tempdb from the C drive but the There may be redundant mdf and ldf files sitting on the C drive which can be

#Local disk c is full free

Out the old error logs and free up much needed space for you. Running this command 6 -8 times in rapid succession will clear You can delete the non-current error logs directlyДЇrom the file system or you can use SQL to elegantly cycle them using the sp_cycle_errorlog In my experience as a DBA I'veДЇound the most common cause of C drive filling up is an over active SQL error log.Д®rror logs that are over 2Gb are not uncommon and when you have 5 or more of these Task when you encounter a Zero free space issue. Here are some tips including a little script to use in an emergency or as a maintenance In a perfect world our C drive would be optimally configured, almost static,Д«ut in the real world we often have many files on the C drive including system databases, Steps you can follow to free up some space in a hurry. Your primary concern is getting your SQL Server back online.

Perhaps your SQL error log is spamming and hasДЇilled up the entire C drive before you've had the chance to address the underlying It happens to all DBAs - your C drive has filled up and your database is about

In this educational webinar, we will cover some of the common issues you may face when working with SQL Server and some of the ways you can troubleshoot these issues. Free MSSQLTips Webinar: Troubleshooting the most common SQL Server Problems