mssql2008R2 RCU-6083:ALTER database FWC SET READ_COMMITTED_SNAPSHOT ON

Endv發表於2014-11-27
SQLDatabaseMIT

RCU-6083:失敗 - 檢查所選元件的先決條件要求:MDS
有關詳細資料, 請參閱 E:\Setup\ofm_rcu\rcu\log\logdir.2014-11-27_12-39\rcu.log 中的 RCU 日誌。
------------------------------------------------------------------------------
Component     : MDS
Error         : Repository creation check failed.
Cause         : Database: 'FWC' is not configured correctly.
Action        : Alter database to turn on the READ_COMMITTED_SNAPSHOT option.
                Ensure you have DBA priviliges. Also the DBA should not have
                multiple logins on this database - else it will result in a
                lock error.
Command       : ALTER database FWC SET READ_COMMITTED_SNAPSHOT ON
-------------------------------------------------------------------------------

RCU-6092:元件選擇驗證失敗。有關詳細資訊, 請參閱位於 E:\Setup\ofm_rcu\rcu\log\logdir.2014-11-27_12-39\rcu.log 的日誌。

 

 

設定資料庫為SINGLE_USER模式,減少鎖定時間 

ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
 
ALTER DATABASE dbname SET ALLOW_SNAPSHOT_ISOLATION ON
 
ALTER DATABASE dbname SET READ_COMMITTED_SNAPSHOT ON
 
ALTER DATABASE dbname SET MULTI_USER

 

相關文章