The state is "RECOVERING".

Say if there was some insert statement runing while i am doing a full backup and the insert was nto complete by the time backup finished, so...

Hmm, is there a way to find when the restore would FINISH.

The qry gives no waiting time it assumes 100% complete but the restore statement issues first is not compelted yet though the database state is "in recovery" instead of "restoring..."

here is the waitinfo ..

(174ms)PAGEIOLATCH_EX:DBNAME:50(*)

yes, from the actvity monitor (sp_who2) it shows me as rolling back.

the percent complete for the sesison i am looking is "0", does it mean it is not rolling back at all?

Also my other question is , does the temp release space to OS after dropping huge temp tables or do we have to shrink or restart the service to reclaim...

Here is what i found after looking in to the tempdb disk usage report.

Though the rserved space is 1500 gb on a single disk it used only 250 gb...

As i have the option to restart the service with new tempdb settings, how about changing the default size of tempdb and create 4 data files in total on 4...

Gila, at this point i am more worried about sql agent as there are many jobs that has to kick off over the week end, its ok for me even...

OK guys.. now i see the log saying database is receovring 11% not sure how long it would take, it is 2.5TB database.

Also i have observed that SQL server Agent...

is there any other option i can do with the existing mdf file and want to get rid if the log file which is too big, i am not worried...

Guys.. fro mthe past 2 days the database is still in the recovery mode wihtout any message in the log, of course the db size is more than 2TB and...

he last message i see for the database is "Starting database" when i have to start the machine manually as it was hung at the shutdown.

I used to see %...

sure , no messages.