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)
>
>
Showing posts with label shipping. Show all posts
Showing posts with label shipping. Show all posts
Monday, March 12, 2012
Replication or log shipping
I have a SQL server with 90 databases (with avg of 30
tables in each) , each needs to be replicated (Transaction
immediate)
The Distrubution databse is on this server. I have been
having problems with some of the database failing to
replicate, and I was wondering if Log shipping between
linked servers would be a better option.
Log shipping replicates the entire database. Replication will allow you to
replicate a subset of the database, allow you to subset the data, but will
not replicate system objects.
While using log shipping your users will have to go offline while the logs
are being applied, and the database must be treated as read only. You cannot
place custom indexes on the subscriber or modify the schema there.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Allan" <allen.penston@.sitel.co.uk> wrote in message
news:02dc01c4dc46$908e68d0$a601280a@.phx.gbl...
>I have a SQL server with 90 databases (with avg of 30
> tables in each) , each needs to be replicated (Transaction
> immediate)
> The Distrubution databse is on this server. I have been
> having problems with some of the database failing to
> replicate, and I was wondering if Log shipping between
> linked servers would be a better option.
>
tables in each) , each needs to be replicated (Transaction
immediate)
The Distrubution databse is on this server. I have been
having problems with some of the database failing to
replicate, and I was wondering if Log shipping between
linked servers would be a better option.
Log shipping replicates the entire database. Replication will allow you to
replicate a subset of the database, allow you to subset the data, but will
not replicate system objects.
While using log shipping your users will have to go offline while the logs
are being applied, and the database must be treated as read only. You cannot
place custom indexes on the subscriber or modify the schema there.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Allan" <allen.penston@.sitel.co.uk> wrote in message
news:02dc01c4dc46$908e68d0$a601280a@.phx.gbl...
>I have a SQL server with 90 databases (with avg of 30
> tables in each) , each needs to be replicated (Transaction
> immediate)
> The Distrubution databse is on this server. I have been
> having problems with some of the database failing to
> replicate, and I was wondering if Log shipping between
> linked servers would be a better option.
>
Subscribe to:
Posts (Atom)