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

As of last reply i tried to taking the backup via SQL server. At that time i am facing the following error message

"cannot open backup device operating system error 3"

I am trying to take the backup to a network location which is already mapped. But the above message is coming again and again. But when i googled , i found that the network location which we have to take the backup also have to be mapped in SQL. For that i executed the following command.

exec xp_cmdshell 'net use X: (XXX.XXX.XXX.XX)\Backup'

go

But the output of the above command also showing that network name is not found. Kindly help me in the crucial situation

Awaiting your earliest reply

Regards

Praveen

[luisdarui]

Hi Praveen,

But this is another thread. In this case you have to work on your other thread https://answers.sap.com/questions/82414/cannot-open-backup-device-operating-system-error-3.html