This article explains why the SQL agent may be taking up a large amount of space in an unexpected location.
During a SQL Transaction Log backup, a large temporary file is created. During a SQL database restore, the related C:\PCBP\Logs.dir\WBPS_* log file reference a path which does not exist on the system. The metadata captured during a SQL Transaction Log backup is the transaction metadata for the database. If there are many changes to the database, this data may become sizable.The SQL databsae restore will attempt to put the metadata on the drive where it was backed up from, event if an alternate location was specified in the Unitrends appliance web interface.
To resolve this issue:
- Add the following to the client-side C:\PCBP\MASTER.INI.
Note: The MASTER.INI path may vary if you installed the agent to a different location.