• SQLSvrStevo (2/27/2012)


    Do the DR databases have to be in standby/norecovery/read-only mode? I have several databases in DR which have been fully restored (as the data is static) I just wish to make sure I'm not breaking any licencing agreements.

    Thanks in advance,

    Steve

    Are the databases used for reporting on or used for any sort or production use? If so they need to be licenced, if not your ok as its not an active server. One thing you could do is set the databases to offline, and have a SQL job which in the event of invoking DR sets them all to online, just as a cover.