After Restore Identity Column mess up

When restore the data from last night backup agter a server failure. My
identiy column values are mess up and showing a different id than was before.
I have this as primary key in my table and store into user station as cookies.
What is wrong an dhow to fix it.
Help desperate
Thansk
Tanweer
I don't know exactly what you are doing but I can't duplicate the problem you
are having. Something is amiss. Are you POSITIVE that your backup file
contains the IDENTITY values that you think they contain? Restore a test
database under a different name and check it out.
|||I tried it on other database and they are ok however this database after a
disk crash is behaving like this.
Thanks
"Scagnetti" wrote:

> I don't know exactly what you are doing but I can't duplicate the problem you
> are having. Something is amiss. Are you POSITIVE that your backup file
> contains the IDENTITY values that you think they contain? Restore a test
> database under a different name and check it out.
|||Disk crash... Any errors from DBCC CHECKDB?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tanweer" <Tanweer@.discussions.microsoft.com> wrote in message
news:07EE4B98-1A80-4606-95DB-3A7ABAF971C3@.microsoft.com...[vbcol=seagreen]
>I tried it on other database and they are ok however this database after a
> disk crash is behaving like this.
> Thanks
>
> "Scagnetti" wrote: