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

Does snapshot in two database has any know issue in following situation. Expand / Collapse
Author
Message
Posted Monday, June 23, 2014 8:14 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 10:04 PM
Points: 52, Visits: 161
Hi,

I have two database D1 and D2, i am using snapshot isolation (ALTER DATABASE MyDatabase
SET ALLOW_SNAPSHOT_ISOLATION ON) in both database.

Following is the situation.
1) situation is one SP sp1 ( it can be in any database d1 or d2) updates d2 from d1.
2) d2 is used for reading by web, execept above SP sp1
3) d1 gets updation from web in readcommite isolation.
4) both database will be on same instence.

i am checking from my side in all possible cases.

q1) please tel me, if any issue can come in this situation.


yours sincerely.
Post #1585143
Posted Tuesday, July 1, 2014 6:56 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 10:04 PM
Points: 52, Visits: 161
Should i post it in any other category?

yours sincerley.
Post #1587994
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse