SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


replica of prod server


replica of prod server

Author
Message
muth_51
muth_51
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2357 Visits: 2928
Hi,
I am trying to create a replica of production server, so that we can divert some traffic. I am thinking of setting up mirroring and taking the database snapshots and making the data available for read only operations and for DR sites. Can we make the data continuously available during the snapshot process for read only operation? It's a high OLTP environment. Can snapshot replication/ Peer to Peer be used over here? We already have transactional replication in prod environment. Can we have both transactional and snapshot/peer to peer replication working together. If yes, what's the impact on prod server? We tried SAN replication but some reason the databases are going to suspect mode. Any thoughts??
muth_51
muth_51
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2357 Visits: 2928
any suggestions????
Bhuvnesh
Bhuvnesh
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12492 Visits: 4077
This document talks about replication and database mirroring (including information on trace flag 1448 which allows the log reader to replicate changes regardless of the mirroring state):

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/ReplicationAndDBM.docx

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
SqlSWAT
SqlSWAT
SSC Veteran
SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)

Group: General Forum Members
Points: 218 Visits: 454
Hi,
Log shipping to a secondary server is also an option . You can query on the secondary log shipping database as well. LS is also very easy to implement.
deep_kkumar
deep_kkumar
Mr or Mrs. 500
Mr or Mrs. 500 (593 reputation)Mr or Mrs. 500 (593 reputation)Mr or Mrs. 500 (593 reputation)Mr or Mrs. 500 (593 reputation)Mr or Mrs. 500 (593 reputation)Mr or Mrs. 500 (593 reputation)Mr or Mrs. 500 (593 reputation)Mr or Mrs. 500 (593 reputation)

Group: General Forum Members
Points: 593 Visits: 756
while restoring the database cannot be accessed in log shipping. Peer to Peer replication just works perfectly over here.
SqlSWAT
SqlSWAT
SSC Veteran
SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)

Group: General Forum Members
Points: 218 Visits: 454
I agree with that. While restoring the transaction logs to the secondary server, the users will be disconnected from the secondary database. Although it is a good practice to setup the backup interval and copy/restore interval of the Logshipping setup same ( Eg. backup trans log every 30 mins , and restore to secondary server every 30 mins) It is not uncommon to setup the log shipping to Restore the Transaction logs only few times a day, so that users won't be kicked out of the restoring database.
Drawbacks are:
Doing so, you would not get an exact near Production copy of the database.
Your Transaction log to be restored in the secondary database will take more time across the network since there will be more transactional log files.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search