February 26, 2002 at 9:42 am
We are trying to restore a database publishes one table via replication to another server. This is the error message we get:
To achieve optimal performance, update all statistics on the 'MyDatabase' database by running sp_updatestats.
Server: Msg 18757, Level 16, State 1, Procedure sp_repldone, Line 333
The database is not published.
RESTORE DATABASE successfully processed 2950061 pages in 4005.658 seconds (6.033 MB/sec).
Our command goes something like this:
RESTORE DATABASE [dbname]
FROM
DISK = ‘\\server\backups\[dbname].bak'
WITH
MOVE '[dbname]_log' TO 'd:\data\[dbname].ldf',
RECOVERY
,REPLACE
Any ideas??
February 26, 2002 at 9:54 am
If you restore a database with published tables to another server you should always get "The database is not published." error as it is just letting you know that it will not be published from the new server. This is to warn/remind you to setup replication again if you need it for this database. Otherwise the database should be fine and a copy of the original.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply