Microsoft SQL Server database ranks third in the relational database, second only to Oracle and MySQL database. when using it, it is inevitable to encounter various problems and warnnings. You may be dba or a developer, I hope this content can help you solve SQL Server error number 18786.

Error number: 18786

Severity level: 16

Event logged: The specified publication does not allow subscriptions to be initialized from a backup. To allow initialization from a backup, use sp_changepublication: set ‘allow_initialize_from_backup’ to ‘true’.