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.

During the backup operation you should not do any action in DB. better you can perform the full DB backup and then start the shrinking..

to my understanding it should have any issues.

Regards

,

Hi Praveen.

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 ?

To my understanding it will not happen any thing, better you can start the full db backup and then do the DB log shrinking. During the backup operation your should not do any activity in the DB,

BR

SS

[Former Member]

SS,

Ok. As per your advice, will do the full DB backup from SAP via DB13. After that will do the shrinking activity via MS SQL server . After that i'll check the size of the transaction log backup file which is now 200 gb.

//During the backup operation your should not do any activity in the DB//

I'll perform the backup operation of QAS in night. So at that time no one will access the QAs server. Is that enough?

Regards

Praveen