Suljettu

I would like to hire a SQL Developer

Database Corruption

Hi we have a production database that has corruption on 4 tables

(47 total errors)

This occured after a power glitch in the server room and of course the power glitch took out the NAS that the backups were on!

Looking for someone who can help analyze and fix the corruption on a Test Environment so that we can then have the production database fixed.

I am a bit green when it comes to SQL, so hence am reaching out for assistance

We are getting error messages such as

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 70291310, index ID 4, partition ID 72057620278804480, alloc unit ID 72057621984509952 (type In-row data), page (1:3636015). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

Msg 8928, Level 16, State 1, Line 1

Object ID 70291310, index ID 4, partition ID 72057620278804480, alloc unit ID 72057621984509952 (type In-row data): Page (1:3636015) could not be processed. See other errors for details.

Msg 2533, Level 16, State 1, Line 1

Table error: page (1:3636016) allocated to object ID 70291310, index ID 4, partition ID 72057620278804480, alloc unit ID 72057621984509952 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

Msg 8976, Level 16, State 1, Line 1

Table error: Object ID 70291310, index ID 4, partition ID 72057620278804480, alloc unit ID 72057621984509952 (type In-row data). Page (1:3636015) was not seen in the scan although its parent (1:3634670) and previous (1:3636014) refer to it. Check any previous errors.

Msg 8980, Level 16, State 1, Line 1

Table error: Object ID 70291310, index ID 4, partition ID 72057620278804480, alloc unit ID 72057621984509952 (type In-row data). Index node page (1:3634670), slot 8 refers to child page (1:3636016) and previous child (1:3636015), but they were not encountered.

Msg 8978, Level 16, State 1, Line 1

Table error: Object ID 70291310, index ID 4, partition ID 72057620278804480, alloc unit ID 72057621984509952 (type In-row data). Page (1:3636017) is missing a reference from previous page (1:3636016). Possible chain linkage problem.

CHECKDB found 0 allocation errors and 6 consistency errors in table 'MVTSTK' (object ID 70291310).

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 316580216, index ID 4, partition ID 72057620270743552, alloc unit ID 72057621975334912 (type In-row data), page (1:3684361). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

Msg 8928, Level 16, State 1, Line 1

Object ID 316580216, index ID 4, partition ID 72057620270743552, alloc unit ID 72057621975334912 (type In-row data): Page (1:3684361) could not be processed. See other errors for details.

Msg 8933, Level 16, State 1, Line 1

Table error: Object ID 316580216, index ID 4, partition ID 72057620270743552, alloc unit ID 72057621975334912 (type In-row data). The low key value on page (1:3684359) (level 0) is not >= the key value in the parent (1:164121) slot 13.

Msg 8934, Level 16, State 2, Line 1

Table error: Object ID 316580216, index ID 4, partition ID 72057620270743552, alloc unit ID 72057621975334912 (type In-row data). The high key value on page (1:3684358) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:3684359).

Msg 8934, Level 16, State 3, Line 1

Table error: Object ID 316580216, index ID 4, partition ID 72057620270743552, alloc unit ID 72057621975334912 (type In-row data). The high key value on page (1:3684358) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:3684359).

Msg 8933, Level 16, State 1, Line 1

Table error: Object ID 316580216, index ID 4, partition ID 72057620270743552, alloc unit ID 72057621975334912 (type In-row data). The low key value on page (1:3684360) (level 0) is not >= the key value in the parent (1:164121) slot 14.

Msg 8976, Level 16, State 1, Line 1

Table error: Object ID 316580216, index ID 4, partition ID 72057620270743552, alloc unit ID 72057621975334912 (type In-row data). Page (1:3684361) was not seen in the scan although its parent (1:164121) and previous (1:3684360) refer to it. Check any previous errors.

Msg 8978, Level 16, State 1, Line 1

Table error: Object ID 316580216, index ID 4, partition ID 72057620270743552, alloc unit ID 72057621975334912 (type In-row data). Page (1:3684362) is missing a reference from previous page (1:3684361). Possible chain linkage problem.

CHECKDB found 0 allocation errors and 8 consistency errors in table 'AD2EVTOF' (object ID 316580216).

Msg 8933, Level 16, State 1, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The low key value on page (1:3868286) (level 0) is not >= the key value in the parent (1:3867913) slot 1.

Msg 8934, Level 16, State 2, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The high key value on page (1:3868285) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:3868286).

Msg 8934, Level 16, State 3, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The high key value on page (1:3868285) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:3868286).

Msg 8933, Level 16, State 1, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The low key value on page (1:3868287) (level 0) is not >= the key value in the parent (1:3867913) slot 2.

Msg 8933, Level 16, State 1, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The low key value on page (1:3868288) (level 0) is not >= the key value in the parent (1:3867913) slot 3.

Msg 8933, Level 16, State 1, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The low key value on page (1:3868289) (level 0) is not >= the key value in the parent (1:3867913) slot 4.

Msg 8933, Level 16, State 1, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The low key value on page (1:3868290) (level 0) is not >= the key value in the parent (1:3867913) slot 5.

Msg 8933, Level 16, State 1, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The low key value on page (1:3868291) (level 0) is not >= the key value in the parent (1:3867913) slot 6.

Msg 8933, Level 16, State 1, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The low key value on page (1:3868300) (level 0) is not >= the key value in the parent (1:3867913) slot 15.

Msg 8934, Level 16, State 2, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The high key value on page (1:3868299) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:3868300).

Msg 8934, Level 16, State 3, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The high key value on page (1:3868299) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:3868300).

Msg 8933, Level 16, State 1, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The low key value on page (1:3868301) (level 0) is not >= the key value in the parent (1:3867913) slot 16.

Msg 8933, Level 16, State 1, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The low key value on page (1:3868302) (level 0) is not >= the key value in the parent (1:3867913) slot 17.

Msg 8933, Level 16, State 1, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The low key value on page (1:3868303) (level 0) is not >= the key value in the parent (1:3867913) slot 18.

Msg 8933, Level 16, State 1, Line 1

Table error: Object ID 353436333, index ID 1, partition ID 72057620274020352, alloc unit ID 72057621978873856 (type In-row data). The low key value on page (1:3868304) (level 0) is not >= the key value in the parent (1:3867913) slot 19.

CHECKDB found 0 allocation errors and 15 consistency errors in table 'ASBARTAG' (object ID 353436333).

Msg 2533, Level 16, State 1, Line 1

Table error: page (1:1307959) allocated to object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

Msg 2533, Level 16, State 1, Line 1

Table error: page (1:1307960) allocated to object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

Msg 2533, Level 16, State 1, Line 1

Table error: page (1:1307961) allocated to object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

Msg 2533, Level 16, State 1, Line 1

Table error: page (1:1307962) allocated to object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

Msg 2533, Level 16, State 1, Line 1

Table error: page (1:1307963) allocated to object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

Msg 2533, Level 16, State 1, Line 1

Table error: page (1:1308036) allocated to object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

Msg 2533, Level 16, State 1, Line 1

Table error: page (1:1308037) allocated to object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

Msg 2533, Level 16, State 1, Line 1

Table error: page (1:1308038) allocated to object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.

Msg 8976, Level 16, State 1, Line 1

Table error: Object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data). Page (1:1307959) was not seen in the scan although its parent (1:1298359) and previous (1:1307958) refer to it. Check any previous errors.

Msg 8980, Level 16, State 1, Line 1

Table error: Object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data). Index node page (1:1298359), slot 290 refers to child page (1:1307960) and previous child (1:1307959), but they were not encountered.

Msg 8980, Level 16, State 1, Line 1

Table error: Object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data). Index node page (1:1298359), slot 291 refers to child page (1:1307961) and previous child (1:1307960), but they were not encountered.

Msg 8980, Level 16, State 1, Line 1

Table error: Object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data). Index node page (1:1298359), slot 292 refers to child page (1:1307962) and previous child (1:1307961), but they were not encountered.

Msg 8980, Level 16, State 1, Line 1

Table error: Object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data). Index node page (1:1298359), slot 293 refers to child page (1:1307963) and previous child (1:1307962), but they were not encountered.

Msg 8978, Level 16, State 1, Line 1

Table error: Object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data). Page (1:1307964) is missing a reference from previous page (1:1307963). Possible chain linkage problem.

Msg 8976, Level 16, State 1, Line 1

Table error: Object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data). Page (1:1308036) was not seen in the scan although its parent (1:1298359) and previous (1:1308035) refer to it. Check any previous errors.

Msg 8980, Level 16, State 1, Line 1

Table error: Object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data). Index node page (1:1298359), slot 367 refers to child page (1:1308037) and previous child (1:1308036), but they were not encountered.

Msg 8980, Level 16, State 1, Line 1

Table error: Object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data). Index node page (1:1298359), slot 368 refers to child page (1:1308038) and previous child (1:1308037), but they were not encountered.

Msg 8978, Level 16, State 1, Line 1

Table error: Object ID 2116918613, index ID 1, partition ID 72057620090847232, alloc unit ID 72057621783576576 (type In-row data). Page (1:1308039) is missing a reference from previous page (1:1308038). Possible chain linkage problem.

CHECKDB found 0 allocation errors and 18 consistency errors in table 'BARTAG' (object ID 2116918613).

CHECKDB found 0 allocation errors and 47 consistency errors in database 'ASTOCKTEST'.

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (ASTOCKTEST).

We tested repair_allow_data loss in our test environment

This repaired okay, and has had no issues since being repaired

However when we did the production database 4 days later, we noted that within 30 minutes, we had the above errors.

This now occurs when we restore to a test and do the repair.

All hardware has been verified as working okay, discs have been tested and moved to different spindles.

The software vendor whose product it is has not assisted as of yet so reaching out to people who deal with SQL on a professional level

Happy to discuss the issue further

Taidot: Tietokannan hallinto, SQL

Näytä lisää: sql server developer for hire ireland, sql developer to hire, sql developer for hire dallas tx, freelance software developer uk hire, where can i find a product developer, which software i prefered for product designing, software developer to hire, software developer to hire for small projects, software developer to hire austin tx, software developer malaysia hire, software developer for hire, software developer for hire uk, need software developer for hire, looking to hire a casino software developer, i need you to develop some software for me i would like this software to be developed for windows using metatrader, hire part time software developer, hire a freelance software developer, freelance software developer for hire, android developer singapore hire, android developer for hire, android app developer for hire, sql hire, asp developer bid hire, iphone developer cost hire, freelance developer sql manila

About the Employer:
( 0 reviews ) Australia

Projektin tunnus: #13172200

13 freelanceria on tarjonnut keskimäärin 235 $ tähän työhön

A2Design

Hi, Nice project you have there, let us help you with it! Our team is Russian-Canadian. We code in PHP. Check our recent projects here [url removed, login to view] Here’s a little video about our team too! ht Lisää

192 $ AUD 1 päivässä
(2 arvostelua)
5.8
mpalgeo

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have Lisää

200 $ AUD 3 päivässä
(30 arvostelua)
5.7
jagdishbhatt38

A proposal has not yet been provided

200 $ AUD 5 päivässä
(13 arvostelua)
4.2
yubor

hi, i am certified mssql server expert (mcse:data platform). would be glad to help you with your problem. at first look i see that you have clustered index pages corruption and related nonclustered (id4). it can be par Lisää

200 $ AUD 5 päivässä
(18 arvostelua)
3.7
amirgull

Hello sir, I have vast experience of SQL Hope you look forward to work with me. Thanks!

100 $ AUD 3 päivässä
(1 arvostelu)
0.4
Sambusiness

Hi , I have read your requirements and for a perfect and professional Website Design and Development, feel free to contact me in case you need to discuss the project or want to see my previous work. I will provide you Lisää

155 $ AUD 3 päivässä
(0 arvostelua)
0.0
sebadlgg

Professional with more than 7 years of extensive experience in designing and development Database applications. Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good kn Lisää

277 $ AUD 3 päivässä
(0 arvostelua)
0.0
dineshspartan

A proposal has not yet been provided

50 $ AUD 1 päivässä
(0 arvostelua)
0.0
ninesol

Hi Sir I will solve this issue within two to five days. Please share some details to start work Regards NineSol

111 $ AUD 5 päivässä
(0 arvostelua)
0.0
coderzzzz

Hi Sir I am ready to solve this error. Regards Shahid ----------------------------------------------------------------------------------------------------------------------------------------------------

333 $ AUD 3 päivässä
(0 arvostelua)
0.0
AppsUNeed

What size is your database? Are you able to provide remote access to your server via a screen-sharing arrangement to support a fix?

111 $ AUD 2 päivässä
(0 arvostelua)
0.0
Splaszczyk

Hi. I work as Senior MS SQL Server DBA ( my certification attached ) . It looks that you have both nonclustered and clustered indexes ( clustered index ID is always equal to 1 in [url removed, login to view]) corrupted. I may help you Lisää

222 $ AUD 10 päivässä
(0 arvostelua)
0.0
dhanuitdevendra

Hello, Hope you are doing well! I'm an Ex-Microsoft CSS (Customer Support & Service) for "SQL Server" 3rd Tier and specialize in Data Recovery. I'll help you in identifying the root cause of the database corru Lisää

500 $ AUD 7 päivässä
(0 arvostelua)
0.0
sonushah813

I have seen the similar issues in the past and successfully resolve the issue. I know one or two possible solutions and if that does not work I will not use more of your time. Even though we will try the fix on Test En Lisää

555 $ AUD 2 päivässä
(0 arvostelua)
0.0