Skip to main content
Solved

Commserve SQL db in restoring state.

  • July 8, 2022
  • 3 replies
  • 162 views

Forum|alt.badge.img+1

Hello Team,

I have quick, maybe simple question.

In what cases sql commserve databases enter in Restoring mode?

 

Regards,

Piotr G.

Best answer by Jos Meijer

Hi Piotr,

This could be due to recovery or replication activities.
Which could be caused by for example:

  • Commserve LiveSync
  • SQL internal replication

I assume this is a standby Commserve and not an active Commserve?
If this is the active Commserve then this should not be happening unless there is human interference.

3 replies

Jos Meijer
Community All Star
Forum|alt.badge.img+16
  • Community All Star
  • Answer
  • July 8, 2022

Hi Piotr,

This could be due to recovery or replication activities.
Which could be caused by for example:

  • Commserve LiveSync
  • SQL internal replication

I assume this is a standby Commserve and not an active Commserve?
If this is the active Commserve then this should not be happening unless there is human interference.


Scott Moseman
Vaulter
Forum|alt.badge.img+22

In the case of CS Live Sync, is the failover SQL Server expected to always be in “Restoring...” state, or should it only be that way if an action (restore job) is running?

Thanks,
Scott
 


christopherlecky
Explorer
Forum|alt.badge.img+16

It should always be in restoring state.