03-15-2016 09:49 AM
Hi,
I have like 50 sql servers and I only have this problem with only one.
When Netbackup runs for transaccional or differential jobs, trn and diff files are being created first on drive C any ideas??
This is weird because so far I know Netbackup never leave any files on sql server.
03-15-2016 11:23 AM
03-15-2016 12:04 PM
Hi Marianne,
Yes Im sure, because when a transaccional job run on netbackup Activity monitior a .tns file is created on local disk. Every job finished successfully
There is no error on event viewer, only a 18265 event. Actually this event is generated at the same time one for backup to disk (local disk) and one for backup to disk (policy storage) and of course the local drive is filling up.
03-15-2016 02:16 PM
You have 50 SQL servers and only one is working differently. On 49 servers NetBackup is not creating any trn or diff files but on one server they appear mysteriously. That should ring a bell that most likely NetBackup is not creating them (or those 49 are not working properly).
Are you using batch scripts for backups or SQL Intelligent Policy? If batch script, could you share the one that is causing the issue?
I'm not an MSSQL expert but are there some parameters/configurations that could be made for a database that could generate logs every time a backup is run of it?
03-15-2016 10:40 PM
03-16-2016 02:25 AM
Hello,
there is a feature called SQL backup mirroring on MS SQL side, but first all mirrors must be of the same type, and second I doubt that it can be used with 3rd party backup SW as a device.
However check if that SQL server is not part of some SQL advanced configuration, like Log Shipping, AlwaysOn, or Database Mirroring. That my guess only - however it is impossible to configure the described behaviour from NetBackup side.
Regards
Michal
03-16-2016 12:01 PM
trn and diff files are most certainly being created by MSSQL and not NetBackup.