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 do it. This gave me following result for my database. name               log_reuse_wait_desc RP2_TEST    LOG_BACKUP IfContinue reading “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”

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 existence of the path you provide and execute the command you provide after that (toContinue reading “How To Write A DOS Bat (Batch) File To Check And Delete A Folder With Contents And Then Self-Destruct?”