Solved

SQL Transactional Replication

Posted on 2013-01-04
3
236 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

785 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