Post reply

SQL 2000 to 2005 Restore

  • July 10, 2006 at 9:30 am

    #114166

    Hi,

     

    I am trying to restore an SQL 2000 backup to SQL 2005.  All seems to go fine in that I get a message that the query completed successfully, and the MDF and LDF files are exactly where I expect them to be, but the status of the database remain in "Restoring" mode and I am unable to move forward.  i have tried stopping and restarting the database as a last resort though but have had no joy.  Has any one come across this or have any suggestions that I might be able to employ.

    By the way, this is an attempt to migrate from SQL 2000 Standard edition (SP4) to SQL Server 2005 Standard Edition.

    Thanks in advance

     

    S

  • July 10, 2006 at 9:43 am

    #648282

    Actually, I seem to have solcved this by removing the With NORECOVERY Option from my restore

  • July 10, 2006 at 9:48 am

    #648283

    I'm not sure if you're using T-SQL or Management Studio to restore, but my first guess would be you selected to leave the database non-operational after the restore which allows for additional log files to be restored.  This would be selected on the "Options" tab of the "restore" using Management Studio.

  • July 11, 2006 at 8:29 am

    #648488

    Also, in the future, if you find that you have inadvertantly left the NORECOVERY option in your restore statement, you can simply run the following statement:

    RESTORE DATABASE <databasename> WITH RECOVERY

    This will recover the database and make it available for use without repeating the entire restore process.

    -- J.Kozloski, MCDBA, MCITP

  • July 12, 2006 at 2:36 am

    #648645

    Thanks for your help guys.

     

    s

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply