SQL 6.5
I have a problem with a large database (9Gb).
When I run dbcc newalloc it returns the error message 2558:
'Extent not within segment: Object ########, indid includes...etc.'
I know why I have the problem - I moved the db to a new server, but didn't use a script based on the original to create the db.
I am getting lots of the above errors and for all segment types.
What I need to know is how to sort it out, I have been all over the internet, through books and documentation and still don't have a clear idea of what I need to do.
Any advice will be gratefully received.
TIA,
Alan Donaldson.
(not a DBA
I have a problem with a large database (9Gb).
When I run dbcc newalloc it returns the error message 2558:
'Extent not within segment: Object ########, indid includes...etc.'
I know why I have the problem - I moved the db to a new server, but didn't use a script based on the original to create the db.
I am getting lots of the above errors and for all segment types.
What I need to know is how to sort it out, I have been all over the internet, through books and documentation and still don't have a clear idea of what I need to do.
Any advice will be gratefully received.
TIA,
Alan Donaldson.
(not a DBA
