Backup exec 2010 SQL agent

Dear All,

             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 ?
mostabdoAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Som TripathiConnect With a Mentor Database AdministratorCommented:
Please re-configure the Publication and run snapshot etc tasks. A restored database can not be used for Publication as you have dropped it. While you drop a database Pu
0
 
Som TripathiConnect With a Mentor Database AdministratorCommented:
... While you drop a database Publication can not be re-used.
0
 
mostabdoAuthor Commented:
Well but i can see the restored Publication in the Databas Publications list,should i delete it and then re configue?
0
All Courses

From novice to tech pro — start learning today.