Viewing 15 posts - 1 through 15 (of 18 total)
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.
November 12, 2011 at 8:50 pm
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...
November 10, 2011 at 1: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:01 am
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...
November 9, 2011 at 11:52 pm
no full text....just sits at 100%
The last two entries in the log are:
(Last Entry)-Recovery is writing a checkpointin database 'MyDB' (9). This is an informational message only. ...
November 9, 2011 at 11:34 pm
wanted to know if others have had issues restore a sql 2000 x86 database to a sql 2008 r2 x64 instance?
November 9, 2011 at 9:58 pm
Applying Service Pack 1 for SQL Server 2008 R2...see if that helps.
November 9, 2011 at 7:56 pm
This is the log as I am doing the restore, I had to restart the entire process but this is the log as I am restoring:
Date,Source,Severity,Message
11/09/2011 16:37:16,spid57,Unknown,Recovery is writing...
November 9, 2011 at 3:47 pm
2011-11-09 15:01:19.86 spid13s A new instance of the full-text filter daemon host process has been successfully started.
2011-11-09 15:01:19.89 spid13s Starting up database...
November 9, 2011 at 2:20 pm
I am also getting a converting database MyDB from version 539 to the current version 661
November 9, 2011 at 2:12 pm
the mdf and ldf files are the correct size as well.
November 9, 2011 at 2:10 pm
Viewing 15 posts - 1 through 15 (of 18 total)