General information
Forum:
Microsoft SQL Server
Title:
Problem with restore of repl db
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!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only