Database restore says (Loading)

I have the exact same problems that are addressed in this article:

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21226369.html

I However, could not get it to work after reinstalling SQL Server 2000 SP3a.  Any other suggestions?

My QA Restore Code:

RESTORE DATABASE Mobile_2 FROM DISK='D:\HTTP\MCSD DB Backup Server-2 050305'
WITH NORECOVERY,
MOVE 'MCSD_Data'
TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\Mobile_2_Data.MDF',
MOVE 'MCSD_Log'
TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\Mobile_2_Log.MDF'

RESULTS:

Processed 4536 pages for database 'Mobile_2', file 'MCSD_Data' on file 1.
Processed 1 pages for database 'Mobile_2', file 'MCSD_Log' on file 1.
RESTORE DATABASE successfully processed 4537 pages in 2.864 seconds (12.974 MB/sec).
Brian CoughterOwnerAsked:
Who is Participating?
 
pai_prasadConnect With a Mentor Commented:
I think the NORECOVERY clause is causing it,,
if its NORECOVERY then SQL Server thinks that u have one more log file 2 restore..

try the same steps with RECOVERY...
0
 
Brian CoughterOwnerAuthor Commented:
Derrr... Thanks!
0
All Courses

From novice to tech pro — start learning today.