Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Azure Plateform through error Expand / Collapse
Author
Message
Posted Wednesday, May 23, 2012 12:48 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:26 PM
Points: 87, Visits: 217
I have two databases one is onpremise and other is on Sql Azure and i have create
a sync group that synchronize a table from on premise to azure as bidirectional sync
that table has 7 crore rows and the sync run approx 8 to 9 hours and at random my table
gets lock and i am not able to select any row from that table.

plz suggest me why dedlock occur and how to prevent this lock.
Whats going worng is there any other way to synchrinize my table from onpremise to azure database.

Thanks!!
Post #1304724
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse