Misconfigured SQL Server causes severe problems in Bamboo

XMLWordPrintable

      USE [master]
GO
ALTER DATABASE [bambooM1] SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
ALTER DATABASE [bambooM1] SET READ_COMMITTED_SNAPSHOT ON WITH NO_WAIT
ALTER DATABASE [bambooM1] COLLATE Latin1_General_CS_AS
ALTER DATABASE [bambooM1] SET MULTI_USER
GO

      The lack of those settings can cause EXPIRY to cause the Bamboo service to hang, for example.

      Please, check if the collation/isolation in the upgrade task and refuse to start if they are incorrect.

            Assignee:
            Unassigned
            Reporter:
            Rafael Sperafico (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: