I'm new here and to SQL. I adopted a database that was being automatically logged to by a SCADA program. The database maxed-out the hard drive; it is now 27GB. I need to get rid of the early half of the data.
However, when I tried to execute a delete statement, I received a message saying that the transaction log is full and won't be able to execute my command.
Can anyone help me with this? Like I said it's about a years worth of data, of which I can get rid of the first 6 months. Does anyone have a good list of procedures to follow for this?