There is no easy way of doing it.

I am sure that database was not cleanly shutdown so you won't be able to use only mdf file to recover the database...

Any manual Log backup *may* break logshipping. be careful.

Would you mind checking DBCC INPUTBUFFER(SPID) to prove the theory pf "real" rollback

As per Books on Line. DEFAULT filegroup should be answer of your question. below is the example.

Please check DBCC Inputbuffer(<SPID&gt and see what this SPID was trying to do.

If you see something like xp_cmdshell or some other OS call, then...

AFAIK there is no option to move the maintenance plan from one server to another.

I feel this post was FYI.

No one can respond this

will there be only 4 "/" or can be more?

Terry,

What is the build of SQL Server you are running?

Please run select @@version and check whether its 8.00.760 or 8.00.818.

If its 818, you will see the dump file generated which...

Could you please check latest SQL Server Error Log. It will be avaialble under <DriveLetter>:\Program Files\Microsoft SQL Server\MSSQL$M<InstanceName>\LOG

Here you will find Port and Protocols where SQL is Listening.

Paste the error...

You will see multiple SPIDs for the same process if the query is going for parallelism.

There is nothing to worry about

You are uninstalling SQL Server because it is not coming up?

Don't give up... Start the SQLServer from the command prompt with Trace Flag 3608 and alter temdb again.

If you nee...

1: Rename the "SQL Server Enterprise Manager.MSC" file under "C:\Program

Files\Microsoft SQL Server\80\Tools\BINN" to "SQL Server Enterprise Manager.xxx"

2: Open MMC (click Start | Run | write MMC...

As poined by others, It depends on Recovery model of the database.

One thing is for sure that you will be able to restore the database if something goes wrong, provided...

select db_name(9)

=> After getting the database name, please run DBCC CHECKDB('DB_Name_Here')

and let us know the result

also please run

select object_name(2043154324) in DBID 9

to get object name.