Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

SQL 2005 Restore ,, odd!

Options
  • 29-08-2007 12:07pm
    #1
    samelterrance
    Closed Accounts Posts: 120 ✭✭


    Hi,

    I've search google on this and couldn't find nought, hoping someone else has seen this.

    I have restored a database from a full backup.
    I received the message "Restore completed successfully".

    When I go back into Management studio and look at my database under object explorer it has

    mydatabase(Restoring...)

    and I can't drill down into the table or anything.
    I've closed down SSMS, restarted services, same thing.
    When I right click and go to properties it says "in the middle of restore".

    But it already said restore completed successfully.

    Any ideas ?

    Cheers


Comments

  • Options
    #2
    scargill
    Registered Users Posts: 1,679 ✭✭✭scargill


    What did you do the restore from ? Are you using backup software like Backup Exec ? If you are, Backup Exec can report that the restore is complete, while SQL server is still busy restoring the database.


  • Options
    #3
    samelterrance
    Closed Accounts Posts: 120 ✭✭samelterrance


    scargill wrote:
    What did you do the restore from ? Are you using backup software like Backup Exec ? If you are, Backup Exec can report that the restore is complete, while SQL server is still busy restoring the database.


    Hi,

    Thanks for the reponse.
    I did a sql server backup to a standard db.bak.
    I restored this file just using SSMS.


  • Options
    #4
    Ginger
    Registered Users Posts: 2,931 ✭✭✭Ginger


    what options did you use when you restored the db?


  • Options
    #5
    samelterrance
    Closed Accounts Posts: 120 ✭✭samelterrance


    Ginger wrote:
    what options did you use when you restored the db?

    Hi,
    Overwrite database, restore with norecovery


  • Options
    #6
    samelterrance
    Closed Accounts Posts: 120 ✭✭samelterrance


    attached is a printscreen of what it looks like!!


  • Advertisement
  • Options
    #7
    samelterrance
    Closed Accounts Posts: 120 ✭✭samelterrance


    samelterrance wrote:
    Hi,
    Overwrite database, restore with norecovery

    Works now, I did the restore with recovery this time and worked.

    Thanks for the responses guys.


Advertisement