Sorry I didn't keep the error message, I was trying to export data from the old table to a new table with  indexed primary ID column,  it took me hours and still...

"If it failed when you tried, it was most likely due to an Enterprise Manager timeout. It will take quite a bit of time to create this column and...

Thanks for reply. Here is the table:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[IISlog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[IISlog]

GO

CREATE TABLE [dbo].[IISlog] (

 [date] [datetime] NULL ,

 [time] [datetime]...

Thanks Tom

Kevin,

How to know that the index is actually 'fragmented'? and if in fact it is 'fragmented', is there any remedy?

Thanks.

Thank you guys for replying.

I just found that there ARE kind of redundant records for the columns I wanted to create index on, so I guess the only way to...

At the moment the database is likely increased 1GB, or less, per day. I can see in the future all data will be required to sort of archived to be...

Happy New Year!

Thank you all guys for the response.

Yes I will try Kevin's suggest to run a query with osql and redirect the output to an external hard drive separate...

Thank you.

No luck, hope is fading.... mdf/ldf are over written, ...

The very bad thing is the file was copied from somewhere else into that folder and over ride the original one.

Are you sure?

For example, usually the database mdf files is in C:\Program Files\Microsoft SQL Server\MSSQL\Data, how would you get it back? Remember I said the database was detached, and then...

Thanks for your quick response.

When I attached the database file, I assume the old one was replaced by the new one. Do you mean the old one still exists somewhere...

DBCC CHECKDB is no use because the database is offline already.

Detach/attach was not working. That tool  "Recovery for SQL Server" saved me.

There is no hardware related crash.

I am not sure if it is the rowversion causing the same error upon crashing database, I assume yes.

What I am thinking is: couldn't this...