Post reply

Genarate reports through Log shipping

  • December 1, 2014 at 12:46 am

    #312813

    Hi All,

    I have one clarification, Is there any disadvantage while using Secondary Database(stand by) to generate the reports.

    Let me explain clearly,

    Suppose I have configured Log shpping between Primary and Secondary Server and I want to use Secondary server to generate the reports using SSRS.

    So any disadvantge to use Stand by Database for generating reports.

    Note: Actually this question has asked by one of interviewer and I could nt give answer. Can someone please help me to get this answer.

    Thanks in advance...

  • December 1, 2014 at 2:01 am

    #1761617

    arooj300 (12/1/2014)

    So any disadvantge to use Stand by Database for generating reports.

    What comes to my mind is that all the sessions using the standby database have to be disconnected when the restore job runs. This is not acceptable in many cases.

    -- Gianluca Sartori

  • December 1, 2014 at 2:16 am

    #1761620

    Doing so means that the secondary server must be licensed.

    Also the disconnection that Gianluca mentioned. If there are log restores running every 15 minutes and a report takes 20 minutes to run, that report will never succeed.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 1, 2014 at 2:25 am

    #1761623

    Thanks Gail and Gianluca for Swift response.

    I got the answer clearly, apart from these two answer if anything is there, please let me know.

    Thanks once again...:)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply