| Uttam Parui[MS] 2002-11-07, 2:23 pm |
| Hello Robert,
Were you backing up the database or restoring from a backup. I have seen
the message
"The database is not published." when we try to restore to a database from
a backup taken of a published database. Apparently from Enterprise Manager
it looks as though the restore has failed, but this message is a benign
warning. The database restore actually goes through fine. Confirm if the
data is being restored by querying tables inside the database. In fact
T-SQL results also give the output "Backup or restore operation
successfully ....". When the database or server you restore
to differs from that on which the backup was created, replication settings
are lost, but the user data is restored. For more information check up
Books
Online topics "Restoring Backups of Replicated Databases to the Same Server
and Database" and "Restoring Backups of Replicated Databases to a Different
Server or Database"
To keep the replication objects, you can restore the database from Query
Analyzer using the option WITH KEEP_REPLICATION
NOTE: KEEP_REPLICATION --> Instructs the restore operation to preserve
replication settings when restoring a published database to a server other
than that on which it was created. KEEP_REPLICATION is to be used when
setting up replication to work with log shipping. It prevents replication
settings from being removed when a database or log backup is restored on a
warm standby server and the database is recovered. Specifying this option
when restoring a backup with the NORECOVERY option is not permitted.
For more info, see SQL Server 2000 Books Online topic "Restore".
Regards,
Uttam Kumar Parui
SQL Server Support Engineer, MCDBA, MCSE, MCT
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
|