Problem with recovering a database

  • Ok, so I have restored a database over the network (16hrs) to standby. I am not sure which subsequent differential I want to apply, so I took the step of detaching the database, copying the files, and reattaching it. 

    Problem now is that it seems to be fully recovered - I can't attach any more backups...

    So, I am assuming it was the attach that recovered it - I may be wrong - is there any way to tell?  Another 16hours of network restore would be miserable...

     

    Ta.

  • The detach/attach should have set your database into a recovered mode.

    Lesson learned: always determine which backups you need to restore before you do the restore.

    -SQLBill

Viewing 2 posts - 1 through 1 (of 1 total)

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