If you are running this as a scheduled task ( From Enterprise Manager, Server Name>Management>Jobs>... ) you can do this to perhaps ignore the error message: From the Steps page frame of the Job Properties wizard, select the task and click the edit button. Once you click the edit button, go to the advanced page frame. There you have the option to choose what will happen when the task "fails" or completes. One of those options is to go onto the next task.

This is a little risky, but it should work. As to how you can supress the error message: I don't know. It would probably require changing a configuration on the SQL 7 db that you may not want to do since it is involved in the snap shot replication. I haven't done enough with replication to be certain. I do know that replication on MS SQL can be pretty finicky.

HTH

>When restoring from a SQL 7 backup device to a SQL 2000 database, I get error 18757 'The database is not published'. I understand why I get the message.....The SQL 7 db is used in snapshot replication, and the replication data will not restore to the 2000 db. However, I have no need for the replication data on the 2000 db. So that isn't an issue.
>
>The restore is successful, and if this was just an occasional restore or done manually, receiving the message really wouldn't matter. However this restore is part of a daily job that restores many dbs. The message is processed as an error and causes the job to stop.
>
>Is there not a way to suppress this message?
>
>Thanks for any help!