| Event Id | 3165 |
| Source | MSSQLServer |
| Description | Could not adjust the replication state of database %ls. The database was successfully restored, however its replication state is indeterminate. See the Troubleshooting Replication section in SQL Server Books Online. |
| Event Information | CAUSE: For a database restore, the server calls sp_restoredbreplication directly to automatically remove replication metadata from the restored database. sp_restoredbreplication removes replication settings if restoring a database to the nonoriginating server, database, or system that is otherwise not capable of running replication processes. This message is returned when sp_restoredbreplication returns one or more errors from the replication cleanup. The message does not stop the restore process, but one or more replication settings or objects may still exist for the restored database. RESOLUTION: Follow these steps: 1. Check the output from the restore statement for other messages that may have been reported along with this one. Troubleshoot any additional errors that were reported. 2. If you do not have access to the original output from the restore, manually execute sp_restoredbreplication on the restored database and troubleshoot any errors that appear. 3. Execute sp_removedbreplication on the restored database to remove all replication. |
| Reference Links | Microsoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 3165 |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.