That will be a life saver. Can it be implemented using inbuilt log shipping of sql server or I need to prepare any customized scripts?
Any link on this will be appreciated if it is some special case.
GilaMonster (7/6/2013)
S_Kumar_S (7/6/2013)
but log shipping will require my database of ServerB to be in restoring mode always, isn't it?No. You can log ship to Standby mode, which allows you to read the database. Not change it, but read it.
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.