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.

1. Refer the link backup action before that stop the SAP Instance

https://www.mssqltips.com/sqlservertutorial/8/sql-server-transaction-log-

backups/

2. After completed the backup. shrink the DB log file from the following link

https://technet.microsoft.com/en-us/library/ms190757(v=sql.105).aspx

Regards

SS

[Former Member]

SS,

Thanks for the links.

Can u pls explain me the concept of Shrink? After shrinking, whether we have to restore the database again? Whether shrinking will affect the live data in QAS?

Regards

Praveen