I have just set up a brand new replication.
Both servers are:
Microsoft SQL Server 2012 (SP3) (KB3072779) - 11.0.6020.0 (X64)
Both publisher and subscriber databases are set to:
Recovery Model: Full
Compatibility Level: SQL Server 2012
In the "Distributor to Subscriber History" tab of the Monitor, it shows up with this error.
'TRUNCATE_ONLY' is not a recognized BACKUP option.
The full error is:
Command attempted:
declare @event_type SMALLINT = 1, @distributor_major_version SMALLINT = 11, @distributor_minor_version SMALLINT = 0, @distributor_build_number SMALLINT = 6607, @totalruntime INT = 7891, @totalworktime INT = 4375, @totalnumtrans INT = 0, @numtranspersec REAL = 0.00, @totalnumcmds INT = 0, @numcmdspersec REAL = 0.00, @totalskippedcmds INT = 0, @totalidletime INT = 0 if object_id(N'sys.sp_repl_generate_subscriber_event') is not null exec sys.sp_repl_generate_subscriber_event @event_state = @event_type,@distrib
(Transaction sequence number: 0x0000A76100001B6F003D00000000, Command ID: 731)
Error messages:
'TRUNCATE_ONLY' is not a recognized BACKUP option. (Source: MSSQLServer, Error number: 155)
Get help: http://help/155