Thanks again. Will research to find some options.

Hi Gila,

Thanks for your feedback. I just wanted to confirm. Any Ideas about restarting a mirror automatically? I have a very highly transactional DB and if the mirror goes down...

Yeah nothing works. I have also installed Microsoft Visual C++ 2008 Redistributable x86 and x86 SP1 and then x64 and x64 SP1 and I still get the same error....

Thanks for the feedback I really appreciate it.

Thanks for the feedback man, I was just wondering and I couldn't find an answer. Now I know 🙂

What is RPO?

I am new in the company, so I did not set up the backups. Do you maybe have an article for me to find out how mirroring works,...

LOL sorry, I didn't read properly and it looked like ID numbers.

Msg 8928, Level 16, State 1, Line 1

Object ID 53575229, index ID 9, partition ID 72057594110935040, alloc unit ID...

I only removed the peoples ID numbers, but nothing else

Hi Gila,

I scripted this DB out and renamed the original one to old..This is where I have dropped the index..I am 100% sure that I ran it against the correct...

Msg 8928, Level 16, State 1, Line 1

Object ID 53575229, index ID 9, partition ID , alloc unit ID (type In-row data): Page (1:1400911) could...

I did check it again, it gives the exact same errors.

Hi Gila,

I have deleted the index but I am still getting the error.

When I use select * from epTracking_dbOld.sys.indexes where object_id = 53575229 and index_id = 9 the record still...

I found it thanks Gila.

It is just a log DB and this error has occurred before, so I just create a new db, and renamed the current one.

Will run that...

I cant find and object with that id

Msg 8928, Level 16, State 1, Line 1

Object ID 53575229, index ID 9, partition ID , alloc unit ID (type In-row data): Page (1:1400911)...