Solved

Backup exec 2010 SQL agent

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Select2 jquery help 9 41
how to fix this error 14 46
Acronis True Image HD 5 29
SQL index creation taking an abnormally long time 2 19
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.
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 install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

708 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