Solved

Backup exec 2010 SQL agent

Posted on 2010-11-29
3
604 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Solution for warm standby SQL server 20 40
How to pass 2 IN parameters to a stored procedure using SQL Server 2008? 6 29
Sql query 107 29
Extract string portion 2 14
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now