Solved

SQL Transactional Replication

Posted on 2013-01-04
3
242 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Downgrading MS SQL 2008 R2 Enterprise to MS SQL 2005 Standard? 12 95
Add a step to a system backup job 6 54
TSQL Challenge... 7 59
(sql serv16)ssis 2016 question/check 1 126
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

734 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