The point is that step 1, 2, and 3 are not possible without a Full Backup. Step 3 will fail.

Steve

I guess that the implied full backup was deleted.

Can unsuccesful, uncommitted or rollback inserts be recovered?

Steve

😎

Yes, I think the statistics are the problem. THere are 39 rows in sysindexes. It contains both stats and indexes.

To get around it, I created...

I wish I was this is the first good lead. But I am just running setup.exe and following the screens.

The server is a VMWare server though.

yes it is a valid id and password. It is working on that server for 2005. I think it is because it is a VMWare server.

Thanks for this, but the error comes up in the install process so there is no config manager to change it.

Steve

No the window does not appear to be open. I go to Windows on the Menu Bar and only Objects Explorer Details and open queries.

I have used...

I don't think i pass the parameter, the database name, to a file.

Steve

No, it's dymanic SQL. I am getting the database file information from a given database.

SELECT FI.[filename] FROM master..sysaltfiles FI Inner Join Master..sysdatabases DB On FI.dbid = DB.dbid Where...

I have more users than that I think it is 300 or so and spread across three sites across the country with the servers in the East. We think...

Well, this is interesting, we have reduced the Processors inolved in Parallelism from 4 to 2. The server has 8 processors. Is that similar to the configuration change you...

Yes there have been SPs picked up in the trace as the heavy CPU users. We have added indexes and done some refactoring but these seem like incremental changes that...

All these things have been checked. Thanks for the suggestions. Please keep 'em coming. Working with MS now and gathering their PSSDIAG traces throughout the day. ...

Yes, but do you mean anything specific?

I understand that I will need to re-install, but will there be any problem with the databases after the re-install. Is there a database conversion from sp3a to SP4...