MS SQL transaction log full - archiving

[VolkerBarth]

Hi all,

Good day.

I 've 3 system landscape here. In my QAS system 4 data files and 1 transaction log is there. When i checked the space only few MB is remaining.

1.jpg

Among 4 data files, the size is about 150 gb and the transaction log is alone near to 200 gb.

Kindly tell me how to increase the disk size ? In this situation should i follow Archiving? If yes, please kindly help me in archiving as till now i didn't done the same.

Kindly help in the above matter.

Regards

Praveen

[VolkerBarth]

You have chosen the "SQL Anywhere" tag, and "SAP SQL Anywhere" is a particular DBMS - as you seem to ask about MS SQL Server, I would suggest that you re-tag the question accordingly so the fitting community members notice your question (in case it is SAP-related at all?)...

(And sorry, I don't know the answer.)

[Former Member]

Done Volker

[Former Member]

Hi Luis,

Thanks for the reply. For your information, i'd like to share some info.

//How often you take transaction log backups// -- As this is a QAS server, till now we didn't take the backup. Daily we are taking the backup of PRD server only( both full backup and transaction log)

//You may shrink your T-Log backup, but it would require it to be truncated, this operation will break the log chain//-- So as per the reply from Sriram, I'll do the shrinking process. But is it necessary to the truncating also? How to do the same. kindly tell

Regards

Praveen