Post reply

Trying restore a db to another instance stuck in restoring

  • January 14, 2009 at 7:15 am

    #198464

    Hi All,

    I am trying to restore a db to another instance on the same server.

    the problem is i keep getting the name of the database with restoring next to it after recieving a message saying it has been restored successfully.

    I have created a back up file under C:\Backup\Backup.bak

    I created a Full Back up.

    When i try the restore i point to this file using management studio

    i use the restore database and point to the BackUp.bak file

    I set the option to NORECOVERY and rename the data and log files.

    the message says it has been restored successfully but keep getting the restoring message next to it.

    I have hit refresh and tried to run a uqery against but get a message that the database is in the middle of restoring.

    I have tried on different size databases and left for over 12 hrs still won't work.

    This is driving me insane

    Can anyone help.

  • January 14, 2009 at 7:21 am

    #926557

    you should have used recovery, not norecovery

    quickest way out of it:

    open a query window and run

    restore database yourdbname with recovery

    ---------------------------------------------------------------------

  • January 14, 2009 at 7:23 am

    #926558

    The problem is that you are using the NORECOVERY option, this will leave your database in a a non-recoverd state so that you can restore further transaction logs.

    If you want to use your database and have no further logs to restore then don't use this option

  • January 14, 2009 at 7:48 am

    #926569

    Sorry should have mentioned that i wanted to use this for a mirror.

    I have just created the mirror and it has worked how i wanted

    thanks

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

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