MS SQL transaction log full - archiving

[former_member183044]

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_member183044]

Done Volker

[former_member197667]

Hi There,

The other way that you can deal with this situation of taking backup on to network drive is by MS SQL management studio.

All you need to do is to create new backup device. Check the below mentioned link.

https://msdn.microsoft.com/en-us/library/ms189109.aspx

You can find this device in SAP and you can create a backup job to this newly created backup device with immediate execution.

Kind regards,

Raghavendra