Solved

SQL Transactional Replication

Posted on 2013-01-04
3
235 Views
Last Modified: 2013-01-07
i just set up transactional replication yesterday. I have 2 servers(Server A and Server B) Server A is my production server and has the publication database on it. Server B is my reporting server and has both the subscription and the distribution databases.  The publication database on Server A gets restored every night from a backup. All day everything ran smooth. Then when publication database got restored I noticed the snapshot agent stopped. How do I keep this from happening? How do I get it started again? keep in mind my topology when answering. Thanks!
0
Comment
Question by:cheryl9063
3 Comments
 
LVL 25

Expert Comment

by:TempDBA
ID: 38746588
Then its better you don't create a replication. Just restore the same database to server B along with Server A every night.
0
 
LVL 1

Author Comment

by:cheryl9063
ID: 38750997
I have to. They want real time reporting up to 5 minutes. This database is 1.5TB in size and simply restoring will not work. So right now I'm only practicing. The real publication database will never get restored unless something bad happens. But what if it does? Based on the topolgy I chose would there be a potential problem?
0
 
LVL 12

Accepted Solution

by:
sachitjain earned 500 total points
ID: 38751209
In such case, you need to stop replication while your publication DB is being restored and once restore is done, you need re-snapshot to subscriber on Server B and restart the replication for rest of the day.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

932 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