My main object of this thread is to find out where\shen the system table is created. It is no longer a problem on this Dev mahcine because the DBA created the table from produciton and flagged it a system table in development.
To answer your questions:
what type of errors?
Database 'DB' was restored, however an error was encountered while replication was being restored/removed. The database has been left offline. See the topic MSSQL_ENG003165 in SQL Server Books Online
does the database has replication turned on in production when you take backup?
if yes, do you restore with "keep replication" option while restoring in dev?
We use LiteSpeed, not sure how to do this
Is your issue solved now or you still need active help?
-- still would like to know where/when the system table is created.
Thomas LeBlanc, MVP Data Platform Consultant