Backup exec 2010 SQL agent
Posted on 2010-11-29
Backup Exec 2010 and i have SQL agent installed.
I used the agent to backup a Published SQL Database.
This database was deleted and i used backup exec to restore this database again, it was restored successfuly.
In SQL server 200 i can see the restored Database and the publication as well, but i can not run any operation on this publication (generate sql script for example or sun snapshot agent ), i always get
Error 20026: The publication "..." doesnot exist.
I tried again with an option "Retain replication settings" ( available in redirection only) but nothing changed.
Is there anything should be done to backup and restore published database successfuly ?