Solved

Restore Replicated database sql server 2005

Posted on 2009-05-19
1
192 Views
Last Modified: 2012-05-07
I have a sql server that uses transactional Replication, I am running a large update on it. If somthing goes wrong I would like to restore from the backup, in sql 2000 I was able to disable  the Distribution agent and I could restore over the database, This doesnt seem to work with 2005. Is there a better way to do this.

0
Comment
Question by:JonMny
1 Comment
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 24424229
I would generate the scripts to recreate all of your subscriptions...that way if something fouls up,  you can run the script to recreate everything.  
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

912 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

19 Experts available now in Live!

Get 1:1 Help Now