Post reply

Subscriptions enabling and disabling on a new server move ???

  • June 25, 2021 at 2:55 pm

    #3900460

    Hi

    We just created a new report server and moved report server db over,

    Both servers are currently running.

    When I use

     

    UPDATE dbo.Subscriptions

    SET InactiveFlags = 1

    GO

    it turns off on both and visa versa...

    is it because jobs are the same name on both servers and both servers can see each other?

    I went and manually disabled the jobs on the old server is this the best way  until the old server is turned of?

     

    Thanks

     

     

     

  • June 25, 2021 at 8:56 pm

    #3900657

    are the two ssrs servers sharing one database server (with two separate databases of course)?

     

  • June 25, 2021 at 8:59 pm

    #3900658

    No, the databases are on each server

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

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