Activity overview
Latest activity by jjim
Thank you Peter/Brain. I am looking forward to receiving this patch version soon.
Jim / comments
Thank you Peter/Brain. I am looking forward to receiving this patch version soon.
Jim
Thank you Jeff for the valuable info.
We have version 4.1.0.207 and this problem has caused me some headaches.
Can Brian or Petey send me version 4.2.0.318 ? We just bought 10 Server licenses 2 weeks ago. / comments
Thank you Jeff for the valuable info.
We have version 4.1.0.207 and this problem has caused me some headaches.
Can Brian or Petey send me version 4.2.0.318 ? We just bought 10 Server licenses 2 we...
Thank you for the quick reply, Brian.
But I did have the FILEOPTIONS=1 inside the code, the Log files in "Done" folder are not deleted:
DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-sql "RESTORE LOG [ECOM_REP] FROM DISK = ''E:\Microsoft SQL Server\MSSQL\BACKUP\LogShipping\ECOM_REP_Logs\LOG__ECOM_REP_*.sqb'' WITH NORECOVERY, ERASEFILES = 6h, FILEOPTIONS = 1, PASSWORD = ''trvel'', MOVETO = ''E:\Microsoft SQL Server\MSSQL\BACKUP\LogShipping\ECOM_REP_Logs\Done''"', @exitcode OUTPUT, @sqlerrorcode OUTPUT
IF (@exitcode <>0) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup job failed with exitcode: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END / comments
Thank you for the quick reply, Brian.
But I did have the FILEOPTIONS=1 inside the code, the Log files in "Done" folder are not deleted:
DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master.....
Transaction Log not deleted after Logshipping
I setup logshipping from one server to another, tran log restored successfully on 2nd server, after that, tran logs are moved to "Done" folder by "MOVETO" command. I also have ERASEFILES = 6h, this...