Tag Info

New answers tagged

0

Case: Accidently When u run below command on Principal server instead of mirror server: alter database 'Database_Name' set partner off After running above command your DB goes in [mirror, disconnected] State on mirror server. Resolution: Step 1:Run below query on mirror exec sp_resetstatus 'Database_Name' Step 2: After running below command your DB will ...


0

The answer of eoinbrazil is partly incorrect. A new Node can be in STARTUP2 for a long time. The link the posted says: Each member of a replica set enters the STARTUP2 state as soon as mongod finishes loading that member’s configuration, at which time it becomes an active member of the replica set. The member then decides whether or not to undertake an ...


2

The index data order on disk for text columns depends on the locales provided by the underlying operating system. The same locales (that is, with the same name) may differ between operating systems on the order rules, even on simple things. As an example this question: PostgreSQL 9.1 streaming replication problem: replica fails to use an index properly ...



Top 50 recent answers are included