RECOVERY Mode to NORECOVERY Mode

  • Dear all,

    I have one doubt/ problem..

    Actually I have recovered my database without complete restoration.

    I have to apply another backups to make it available from the point of failure..

    Is it possible to change the Recovery mode to Norecovery mode.

    Is there any solution for this..

    plz reply..

    Regards

    Majid

  • as far as I know that is not possible.

    You'll have to restart from your fullbackup and keep it in Norecovery until you decide to use recovery.

    At that time it will rollback all uncompleted transactions (based on the transaction log)

    btw, you can keep your db in norecovery mode and then if you decide that you've reached a point to activate the db , you can just perform

    ....

    /*

    -- I think now I'm ok with the data

    restore database mydb with recovery ;

    */

    btw with sql2005 if you perform a pit-restore and it hasn't reachted the PIT, it will leave the db/filegroup in norecovery mode.

    However, it will give a warning it has left the db in norecovery mode.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • You will have to start the restore process again from the full backup onward. Were users connecting to the database and performing transactions after you brought the database online? If yes, when you restore to the previous point in time you will lose any changes that have since been added in the incomplete restore.

  • What happens though if I am constantly getting log files every hours and I need to access the DB?

  • restore with standby.

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

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