Kun Lee had a database where the log file kept growing and used 99.99% of the available space. He noticed miscellaneous change data capture objects still in the database as well as open transactions. This was causing his transaction log to continue to grow, but he couldn't disable CDC, because SQL Server thought it was not enabled. Read the full article to see his solution.
In the select statement I changed the table name where your retrieving the date.Thanks Again UPDATE AE SET AE.count_fact = dtCounts.count_fact FROM #tmp_ar_exception AE INNER JOIN ( SELECT DISTINCT #tmp_ar_exception.dt_id, COUNT(F_AR_Detail.date_id) AS count_fact FROM #tmp_ar_exception LEFT OUTER JOIN F_AR_Detail ON #tmp_ar_exception.dt_id = F_AR_Detail.date_id GROUP BY #tmp_ar_exception.dt_id ) dtCounts on AE.dt_id = dtCounts.dt_id
We made the decision to run it in Simple mode, but I had left it in Bulk-logging while I tried to find a pattern. I knew that there were some other things that may need to be pulled into a Trans log backup when the DB is in Bulk logging, but I would have never […]
Fair enough, Farrell. I too am quite skeptical everytime I hear that 'the xyz worm caused a bazillion dollars worth of damage to the industry' or whenever I hear whatever the media 'caution du jor' happens to be. I mean, I'm supposed to use plastic and duct tape to protect my house in the event […]