Forum / Remote Desktop Manager - Support

Upgrade to Enterprise 10.0 - DB upgrade failure

  • Create an Issue
  • Cancel

I upgraded to v10 this morning. After the install completed, I was prompted to upgrade my database, schema 91 to 93.

Well....I got an error and I'm stuck.


"2014+09+23+13+00+46"

I ran DBCC CHECKDB and located identified corruption in the "connectionlog" table.

I switched the table to single user mode, then ran DBCC checktable:
DBCC Checktable ('connectionlog', REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS, NO_INFOMSGS;

However, I can't repair the error.

Msg 8945, Level 16, State 1, Line 1
Table error: Object ID 373576369, index ID 1 will be rebuilt.
Could not repair this error.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 373576369, index ID 1, partition ID 72057594039107584, alloc unit ID 72057594040352768 (type In-row data). Page (1:2931) was not seen in the scan although its parent (1:8621) and previous (1:8017) refer to it. Check any previous errors.
The error has been repaired.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 373576369, index ID 1, partition ID 72057594039107584, alloc unit ID 72057594040352768 (type In-row data). Page (1:7731) is missing a reference from previous page (1:2931). Possible chain linkage problem.
The error has been repaired.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'ConnectionLog' (object ID 373576369).
CHECKTABLE fixed 0 allocation errors and 2 consistency errors in table 'ConnectionLog' (object ID 373576369).

Any ideas?

2014-09-23_13-00-46.png
Clock6 yrs

Hello,

Updates 91 to 93 create two indexes, not something risky.

The connectionLog table contains logging data, if you cannot restore from a backup you could drop and recreate the table, but it would be best to restore your latest backup and redo the upgrade.

Best regards



Maurice Côté

signaturesignature

Clock6 yrs

Hi...I'm not a SQL expert.

The repair options were gleened from the google searches.

Can you provide the script to drop and recreate the table?

I don't have a recent backup to restore, aside from the manual backup I ran prior to the repair attempts.


Maurice Cote wrote:

Hello,

Updates 91 to 93 create two indexes, not something risky.

The connectionLog table contains logging data, if you cannot restore from a backup you could drop and recreate the table, but it would be best to restore your latest backup and redo the upgrade.

Best regards

Clock6 yrs

With the output you posted, it looks like some errors were resolved. Could you please re-run the DBCC command and post the result here?

Stefane Lavergne

signaturesignature

Clock6 yrs

Hi...

I've run it couple times...same errors messages (from above) keep appearing.

Clock6 yrs

We have two choices:

- delete the table & re-create
or
- try to save the data by fixing the error (more complex)

Let me know which one you prefer & I can help you with the SQL statements.

Regards,

Stefane Lavergne

signaturesignature

Clock6 yrs

What's in the connectionlog table?

Clock6 yrs

The logs (open, close, create, modify) by who & when.

Stefane Lavergne

signaturesignature

Clock6 yrs

I'm the only user...we can drop the table.

Clock6 yrs

I've sent you a private message.

Stefane Lavergne

signaturesignature

Clock6 yrs

Now that it works, I would suggest you schedule regular backups.

You can have a look here: http://help.remotedesktopmanager.com/index.html?bestpractices_backups.htm

Best regards,

Stefane Lavergne

signaturesignature

Clock6 yrs