November 14, 2019 at 2:13 pm
After the patching, one of the database goes into Not synchronizing / suspect state. I resumed a data movement manually. It goes into recovery pending to suspect. This is from the log file 'DB has been suspended for the following reason: "system" (Source ID 2; Source string: 'SUSPEND_FROM_REDO'). To resume data movement on the database, you will need to resume the database manually."
Any help is highly appreciated.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
November 14, 2019 at 2:42 pm
Check the error log , could be where you have apply a log backup in the sequence.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 14, 2019 at 3:11 pm
I am restoring a DB with no recovery. I will then just join the DB.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
November 14, 2019 at 5:15 pm
Its back online and in sync. Took the backup, paused the data movement, restore the DB, join the DB and that's it.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
November 15, 2019 at 12:09 pm
I am restoring a DB with no recovery. I will then just join the DB.
If the DB is small, yes you can configure again.
How to fix the LSN issue: https://www.sqlserverblogforum.com/alwayson/how-to-solve-the-lsn-mismatch-in-sql-server/
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply