Backup / Restore Log Shipping

• sqletom

  SSC-Addicted

  Points: 438

  More actions

  August 13, 2004 at 7:13 pm

  #162434

  I just came across something very strange, that I have yet to prove but would like to ask all of you out there if you have seen anything similar:

  I'm using log shipping. Backup log from server-1. Copy files to server-2. Files are restored on server 2.  Performance no server 2 is terrible, it's low on memory and on disk space. I compressed the folder where the transaction log files reside, suddenly my CPU utilizations drops to almost nothing.

  Is this because the server is paging less? I would assume so, but uncompressing files would surly cost some CPU too?  I've never been so short on space where I had to compress the folder before...

  Any comments would be appreciated.

   

• August 16, 2004 at 8:00 am

  This was removed by the editor as SPAM

• robertk

  SSCommitted

  Points: 1608

  More actions

  August 17, 2004 at 10:25 am

  #519391

  How fragmented is the destination drive where you're shipping the files to?