Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 622
  • Last Modified:

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 ?
0
mostabdo
Asked:
mostabdo
  • 2
2 Solutions
 
Som TripathiDatabase 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 TripathiDatabase 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now