June 7, 2017 at 8:08 am
Hello All,
in my log shipping the SQL Server backup the T-logs by create trn files.
the file name format is:
DBNAME_20170101000001.trn
DBNAME_20170101001001.trn
DBNAME_20170101002001.trn
My question is:
Is it possible to change the format of the file name?
Can the file name contain also milliseconds?
Thanks in advance!
June 7, 2017 at 8:32 am
Log Shipping is controlled through an executable "sqllogship.exe", so I don't see how you can change the output format, unless you create a manual process with T-SQL or PS.
For PS options, see PS
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 7, 2017 at 9:37 am
89netanel - Wednesday, June 7, 2017 8:08 AMCan the file name contain also milliseconds?
Just interested to know what you think this can provide
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply