UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Delete Job Failing, Any Versions    
 
   
ordnance1
post May 26 2019, 11:51 PM
Post#1



Posts: 648
Joined: 7-May 11



Every second I import data into table DataNow (86,400) lines of data a day. At midnight I have a job which archives that data in 10 minute intervals. I then run the code below to delete the prior days data from table datanow. This worked well for a few days but now the job fails with the following error message:

Msg 9002, Level 17, State 4, Line 1
The transaction log for database 'WeatherFlow' is full due to 'ACTIVE_TRANSACTION'. The log file doesn't seem to large so not sure what I need to do.


CODE
DELETE
    DataNow
WHERE
    DATEADD(D, 0, DATEDIFF(D, 0, RecordDate)) = DATEADD(D, 0, DATEDIFF(D, 1, GETDATE()))


Attached File  screenshot.png ( 98.47K )Number of downloads: 4
Go to the top of the page
 
cheekybuddha
post May 27 2019, 03:52 AM
Post#2


UtterAccess VIP
Posts: 11,464
Joined: 6-December 03
From: Telegraph Hill


https://duckduckgo.com/?q=Msg+9002%2C+Level...brave&ia=qa

--------------------


Regards,

David Marten
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    24th August 2019 - 08:15 PM