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
Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

SQL 2005 Restore ,, odd!

  • 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

  • #2
    scargill
    Registered Users, Registered Users 2 Posts: 1,684 ✭✭✭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.


  • #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.


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


    what options did you use when you restored the db?


  • #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


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


    attached is a printscreen of what it looks like!!


  • Advertisement
  • #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