Link to home
Start Free TrialLog in
Avatar of cheryl9063
cheryl9063Flag for United States of America

asked on

SQL Transactional Replication

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!
Avatar of TempDBA
TempDBA
Flag of India image

Then its better you don't create a replication. Just restore the same database to server B along with Server A every night.
Avatar of cheryl9063

ASKER

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?
ASKER CERTIFIED SOLUTION
Avatar of sachitjain
sachitjain
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial