November 9, 2011 at 11:52 pm
4 gig mdf and 4 gig ldf. I have upgraded to SP4 on SQL 2000 and SP1 on 2008 R2, and tried to restore again. This time the activity monitor at least says Running for the Restore, previously it said Runnable in the Task State; however, if I run sp_who2, the Status is RUNNABLE....so I am confused as to what is actually happening.
November 9, 2011 at 11:53 pm
took about 15-20 min to get to 100%
November 10, 2011 at 12:01 am
patrick-511016 (11/9/2011)
4 gig mdf and 4 gig ldf. I have upgraded to SP4 on SQL 2000 and SP1 on 2008 R2, and tried to restore again. This time the activity monitor at least says Running for the Restore, previously it said Runnable in the Task State; however, if I run sp_who2, the Status is RUNNABLE....so I am confused as to what is actually happening.
It stuck again? Did you attempt for fresh BACKUP & RESTORE?
November 10, 2011 at 12:01 am
SELECT session_id as SPID, command, a.text AS Query, start_time, percent_complete, dateadd(second,estimated_completion_time/1000, getdate()) as estimated_completion_time
FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a
and percent_completed for the restore is 100%
November 10, 2011 at 12:02 am
yes I have tried it again and it is stuck
November 10, 2011 at 12:16 am
patrick-511016 (11/10/2011)
yes I have tried it again and it is stuck
Is there anything else running on server (for the said database) in parallel to restore?
November 10, 2011 at 12:22 am
nope
November 10, 2011 at 12:44 am
If something is blocking restore, then it should appear in error log or activity monitor.
By the way, the server where you restore is there any strain of old database (files)? If yes, delete those files as well. Don’t overwrite it in restore operation.
November 10, 2011 at 1:01 am
new instance on a different server, and I delete the any old files that create. Keep in mind, the mdf and ldf actually load into the data directory, it just wont move past 100%
November 10, 2011 at 3:04 am
It's hanging on one of the upgrade scripts. There's a whole lot of upgrade steps that have to run and there's only one listed in the log.
Is the restore process waiting for something? If so, what's the wait type and what's the wait resource?
Do you still have a SQL 2000 instance there?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 10, 2011 at 7:03 am
Is this as simple as refreshing object explorer since the restore is at 100%?
Is the query still showing as "executing"?
November 12, 2011 at 8:50 pm
alright, after two days of 12 hours days of working on this, I am back at it. I will see if a new instance gives me any better luck.
Viewing 12 posts - 16 through 26 (of 26 total)
You must be logged in to reply to this topic. Login to reply