mssql2008R2 RCU-6083:ALTER database FWC SET READ_COMMITTED_SNAPSHOT ON
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