Tag Archives: do

The transaction log for database is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

09-10-2012 I got this error today for one of my test databases. Following are the steps to solve this. Step 1 The error message gives a hint to look in the log_reuse_wait_desc column in sys.databases table. So we will just … Continue reading

Posted in SQL Server | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

How To Write A DOS Bat (Batch) File To Check And Delete A Folder With Contents And Then Self-Destruct?

05-09-2012 How to write a simple bat file (DOS command batch file) to find if a directory exists and delete it with all items in it (all files and sub folders). Simple DOS command explanation: IF EXIST will check the … Continue reading

Posted in General Computing | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment