SQL Server Performance

Shrink Log Ship DB

Discussion in 'SQL Server Log Shipping' started by rhankin, Nov 21, 2007.

  1. rhankin New Member

    Read Only Databases can not be shrunk. My Log Shipped Database has many GB of data unused in the data file and the transaction log. Is there anyway of removing this?
    My Transaction log is only using 20MB but has 29GB of unused space - my biggest transaction files get to 1 or 2 GB maximum
    Thanks in advance!
  2. ranjitjain New Member

    Hi,
    If you feel that you dont need TX log completely, then you can detach the db, rename tx log, and re-attach and new tx log will be created. But this way could be risky as a new log file will be created and will have no past logging history.

Share This Page