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
TanweerI 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...
>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.