Restoring Logs - Empty Logs

• Carol Adams

  SSCrazy

  Points: 2320

  More actions

  September 11, 2014 at 8:43 am

  #311491

  I have a job that retrieves log files from an FTP site, then restores them into a local database.

  The issue I am having is if a log file is empty, the restore aborts and I have to remove the empty log file from the directory. Then restart the process.

  Is there anything I can run that will let me know that the logfile is empty so I can automate this process?

• aahale

  Valued Member

  Points: 58

  More actions

  September 11, 2014 at 11:53 am

  #1744892

  What is the method you are using to load the log file into the database? SSIS, bulk insert, etc?