sql server log shipping space consumption -

sql server log shipping space consumption -

i have implemented sql server logs shipping hq dr server

the secondary databases in standby mode .

the issue after configuring , dr server running out of space rapidly

i have checked log shipping folders trn files resides , of decent size , , retention configured 20 4 hours

i checked secondary databases , size same of corresponding primary databases

could guys please help me out in identifying reason behind odd space increase

i grateful if point me online resources explains matter depth.

i check see how transaction files managed on primary , secondary. there re-create job ships backup leaving transaction log backup on primary , secondary. check create sure retention policy on both set 24 hours. also, there initial backup gets created , might want create sure deleted after initialized log shipping process.

i create verify log file on primary maintained plenty aren't getting unnecessarily big transaction backups.

but, if you're on top of already, seek , utilize tool windirstat see files on server taking disk space. may uncover not straight related log shipping (page file, maybe?)

https://windirstat.info/

sql-server sql-server-2008 log-shipping