Database restore says (Loading)

Posted on 2005-05-03
Last Modified: 2010-03-19
I have the exact same problems that are addressed in this article:

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'
TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\Mobile_2_Data.MDF',
TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\Mobile_2_Log.MDF'


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).
Question by:Brian Coughter
    LVL 10

    Accepted Solution

    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...

    Author Comment

    by:Brian Coughter
    Derrr... Thanks!

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now