cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Remote Consolidated Database Recovery After Passthrough

JimDiaz
Participant
538

SQLA 17.0.10.6160

Our operations center performs full backups of our consolidated database weekly and incremental backups before and after each dbremote run. These incremental backups are applied to the validated full database backup daily. This process has been in place for years. Recently sometime after our upgrade to SQLA 17 the application of the log files are failing occasionally.

I have received three log files which failed to apply on three different occasions, each of these files when translated included a SQL Remote passthrough statement.

I believe we may have a BUG...

Thanks for the help.

Jim

regdomaratzki
Product and Topic Expert
Product and Topic Expert
0 Kudos

What error are you getting when you apply the transaction log?

JimDiaz
Participant
0 Kudos

No error is given the process just hangs at ... recovery 0% complete

Breck_Carter
Participant
0 Kudos

> a SQL Remote passthrough statement

What kind of statement(s)? Different kinds, or the same kind on all three occasions?

Can you create a small, separate reproducible? I.e., tiny databases with just enough DDL to reproduce the symptom.

JimDiaz
Participant
0 Kudos

Let me see what I can do to recreate on a smaller database. I will also get a copy of the last db log file that caused the error.

VolkerBarth
Contributor
0 Kudos

Recently sometime after our upgrade to SQLA 17 the application of the log files are failing occasionally.

So what version have you been using before?

regdomaratzki
Product and Topic Expert
Product and Topic Expert
0 Kudos

Would you be able to generate a dump file from Task Manager of the dbsrv17 process when it's hung and provide :

  1. The dump file
  2. The dbsrv17 start line
  3. The output from dbsrv17
  4. The transaction log it was applying when it hung

If yes, I'll provide a location for you to upload to.

Reg

JimDiaz
Participant
0 Kudos

16.0.0.2798

JimDiaz
Participant
0 Kudos

I've requested this data but I'm not sure what's available at the very least I can arrange for them to collect it after the next passthrough

JimDiaz
Participant
0 Kudos

Reg,

I've got everything but a dump file there was none because the process hung it didn't crash. Let me know how best to get this to you.

Accepted Solutions (0)

Answers (0)