<div>
Well but i can see the restored Publication in the Databas Publications list,should i delete it and then re configue?
</div>


Well but i can see the restored Publication in the Databas Publications list,should i delete it and then re configue?

<div>
<div class="content wysiwyg-content">
Dear All,<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Backup Exec 2010 and i have SQL agent installed.<br />
<br />
I used the agent to backup a Published SQL Database.<br />
<br />
This database was deleted and i used backup exec to restore this database again, it was restored successfuly.<br />
<br />
<br />
<br />
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<br />
<br />
<br />
<br />
Error 20026: The publication &quot;...&quot; doesnot exist.<br />
<br />
<br />
<br />
I tried again with an option &quot;Retain replication settings&quot; ( available in redirection only) but nothing changed.<br />
<br />
<br />
<br />
Is there anything should be done to backup and restore published database successfuly ?<br />

</div>
</div>


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 ?


Backup exec 2010 SQL agent

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.

Storage Software

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.