Monday, March 12, 2012

Replication or Log shipping

If i want to my test server database should be in sync with my prod database,
which one is the best. after complete data sync i dont want any data updates.
i am going to setting up only one way, from prod to test.
please advise if any risks or issues
John,
please take a look here and post back with any questions:
http://www.replicationanswers.com/Standby.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I know it Paul, i saw in your web site in the past. just curious if any other
issues or concerns.
thanks to you and Hilary, may god bless you two people for saving so many
DBA's tough time.
thanks once again
"Paul Ibison" wrote:

> John,
> please take a look here and post back with any questions:
> http://www.replicationanswers.com/Standby.asp
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>

No comments:

Post a Comment