Database Restoring taking too long!!!

  • Hello

    I have job enabled on one of my servers, with the task of taking a database offline and backing it up, and the perform a restore - all to be completed within an hour.

    I have looked at the job history and everything seems fine, but at the moment, the restoration seems to have frozen or something, as it has been saying 'db' (Restoring....).

    Can anyone help me out as I have run out of ideas and users need to generate reports as soon as possible.

    Thanks

  • Did you restore the database using with norecovery option? Try this,

    Restore database dbname with recovery

    [font="Verdana"]- Deepak[/font]

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

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