Jesse Reich (6/5/2012)

---

Alternatives:

· Use transactional replication

· You could automate the process of creating a new publisher and subscriber

· The new publisher / subscriber would be created each time a...

Jesse Reich (6/5/2012)

---

I'm not entirely clear on some of the details. Is it an existing process which creates the daily database on the primary server? Or are you also asking...

vinu512 (6/5/2012)

---

If the Database at the Primary Server gets updated every 2 seconds and you want the Db at the Secondary Server also to get updated the may be you...