September 11, 2014 at 8:06 am
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?
September 11, 2014 at 12:01 pm
What method are you using to load the log file. SSIS, bulk insert, etc?
September 11, 2014 at 1:59 pm
EXECUTE master..sqlbackup '-SQL "RESTORE LOG [XXX] FROM DISK = ''D:\xxx\TransactionLogs\*.sqb'' WITH PASSWORD = ''xxxx'', MOVETO = ''D:\xxx\TransactionLogs\Processed'', STANDBY = ''D:\XXX.undo'', DISCONNECT_EXISTING, ORPHAN_CHECK"', @exitcode OUTPUT, @sqlerrorcode OUTPUT
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy