SQL error log file is rapidly growing and it has reached in size 43 GB so how can I delete it safely? I guess a transaction log file of a database has caused so when I look at the sql log file thera are lots of messages " Transaction log for the database XXX is full" so I guess this is the reason why error log file was huge..
the question is that how can I delete old error log file safely or another way?please attached file
other question. the transaction log of this database is alwasy rapidly growing and I am shrinking this log file everyday so How can I bring under control this transaction log of this database?