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 Matt,

Thanks for the reply.

If we are taking backups, should the size will decrease ? Then is there any need of shrinking again?

Regards

Praveen

,

Hi Matt,

Thanks for the reply. Kindly note the below points

1. //You probably should do regular backups of your QAS system, even if you don't keep the backups very long// - Till now we didnt take the backup of QAS (Quality system). In our environment, we are daily taking full backup and transaction backups.

2. //my recommendation is to take a full backup of the database, then do a transaction log backup. This will "empty" the transaction log, though it will not shrink it (it will stop the growth). However, it has to be empty before you can shrink it.// - Here u mentioned as first i should take the backup ( both full and transaction). If we taking backups regularly, then the size would decrease or not? If then , is there any need of shrinking?


Regards

Praveen