Post reply

Question on report databse

  • July 17, 2020 at 2:18 pm

    #3770838

    Hi,

    I manage our local databases server, and recently our company set one up on Azure. I am not as familiar with Azure a person, with more experience with Azure,  set it up.

    Anyway, database wise everything looks good, but I noticed that there is no reporting server or report server TempDB.

    Now we do nothing in SSRS, and the reports that SQL server provides are working, but I was wondering if we need this for any reason; epically if we are not using SSRS?

    Thank you

  • July 17, 2020 at 2:49 pm

    #3770852

    ReportServer and ReportServerTempDB are databases used exclusively by SSRS.  If you are not using SSRS, you don't need those.

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • July 17, 2020 at 4:17 pm

    #3770891

    Okay, that is what I thought.

     

    Thanks

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

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