May 20, 2002 at 9:37 am
Has anyone run into this problem?
I have a database (called db1) on a server called SQL1. db1 is replicated to a server called SQL2.
I want to restore the most recent backup of db1 to SQL1 with the name db1Test. When I run the restore in Enterprise Manager I get the following error:
The database is not published.
When I take the same backupfile and move it to our development environment I can restore it and everyhting is fine.
Has anyone seen this and do you know how to make the restore work on SQL1?
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
May 20, 2002 at 10:51 am
I get this usually anytime I change the name or do not restore back to a server that is replicated. I believe it is due to the fact that the publication is a named item and you cannot have 2 with the same name on the server and if you drop the first name copy before restore it should restore without the message. Sorry but I have not tried this as of yet. Anyway you will get this on a server without replication as well. If you restore to a server that with replication enabled I believe you still have to setup the subscribers but you won't have to setup the publication.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 20, 2002 at 5:00 pm
I think thats correct - it's restores put replication is not set up entirely.
Andy
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply