Well, if not the DB backup..there should be tape backups of the drives on which these files were placed.. I restored one of my MDF files from the tape which...

Rolling upgrade is not supported for SP2.

Thanks!!

Follow the link for a detailed installation guide...also be advised that it requires a reboot...

http://support.microsoft.com/default.aspx?scid=kb;en-us;328839

[font="Comic Sans MS"]

...

DBCC Checkident corrected the seed value on both test and the actual db..thanks a lot Gail..

The primary key is on the Identity..which I am not referencing while doing the insert.

How do I reseed this field..if so will it fix the problem with the insert?

Thanks Again!!

Don't now why I get this error when I try to do an insert on the table after the repair was run. The table has an identity key.

insert into tblTransactionResponse...

I will wait until Jan 5th probably..as I dont see any other options either. I have attached the detailed logs after running various commands. I ran these CheckDb commands by...

I am posting the detailed error report.

When I run select * on the table I get the error as

Server: Msg 7105, Level 22, State 6, Line 1

Page (1:75439), slot 12...

I support kandal.vandyke's purpose of starting this post as I am curious to know the detailed technical difference between the two RAID's..but would like to throw some stuff from...

sayfrend (12/23/2008)

Steve Jones - Editor (12/23/2008)

Thats what makes you an editor of forum like SQL Server Central. You are Simple Best !!!

I Want to have as much knowledge as...

The Dev or UAT server needs to be in available state during and after the refresh process...

I guess I am referring to the literal meaning..like database not in suspect state or offline...as long as it is not in these states I would be fine saying the...

Make sure you backup prod and dev/UAT before you drop of create anything..as it is the first time you are doing it better be safe than be sorry...Good Luck!!

Thanks!

looks like sql 7 doesn't support device backups..i tried time and again but its copying only to a single file. I believe i ll have to have a dedicated disk...