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

[S_Sriram]

Hi Praveen.

Its not required to restore the DB and Shrink will not affect the database. Kindly follow the steps as mention below. we have faced this issue so many time in our environment.

1. Stop the SAP instance.

2. Run the Transaction log backup.

3. Shrink the transaction log file. Transaction log file shrinking is to release the free disk space.

4. Once again check the over the free disk space in Transaction log & Ms Sql DB files.

5. Start the SAP instance.

BR

SS

[Former Member]

SS,

Thanks for your reply. Will do the same in our environment and let you know the status.

Regards

Praveen

[Former Member]

SS,

One more doubt? If we shrink the transaction log file and if any problem happens what will we do? At this point can we do the full backup ?

Regards

Praveen