syspublication tables not included in database restore :(
-
Hi,
I have just restored a db from a backup and can't now get replication going again.
Since the restore the syspublications table has not been restored.
We did switch off replication prior to the bakup and we used LiteSpeed.
When backing/restoring a database is the table syspublications included?
The database backup was only only 1 hour old.
Any help welcome.
Eamon
-
' managed to get this fixed ok and here's what I did.
1. I took the database OFFLINE.
2. In windows explorer copied the files to a different drive.
3. Deleted the OFFLINE database.
4. create a new db with the same name.
5. detach this db.
6. Deleted the files of the detached db.
7. Copy the original database file back into their original location again.
8. Attach the original db again.
9. Try Set up of replication again
Success
It may have been something screwed up in the master db but it's all sorted now.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply