September 13, 2010 at 3:20 am
Hi All,
DETAILS :- I have 2 servers for log-shipping. 1st server as Active server & 2nd Server as Stand by (Passive) server & 2nd server i am using as a reporting purpose.
QUE :- If i change VARCHAR (50) to VARCHAR (100) in st server or active server, can it is possible in nd server automatically update?
Please explain me briefly................................
September 13, 2010 at 3:37 am
yes it will be automatically refreshed on secondary but it depeneds on how frequently you refreshing you secondary by log backup of primary..
----------
Ashish
September 13, 2010 at 5:56 am
Thank You Ashish,
Could you explain me........ because STAND BY server (2nd server) already i am using for reporting purpose that movement if i change data type in active server (1st server) how it change? or any effect ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply