Solved

Backup exec 2010 SQL agent

Posted on 2010-11-29
3
606 Views
Last Modified: 2012-05-10
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
Comment
Question by:mostabdo
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
Som Tripathi earned 500 total points
ID: 34233661
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
 
LVL 8

Assisted Solution

by:Som Tripathi
Som Tripathi earned 500 total points
ID: 34233691
... While you drop a database Publication can not be re-used.
0
 

Author Comment

by:mostabdo
ID: 34236789
Well but i can see the restored Publication in the Databas Publications list,should i delete it and then re configue?
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question