none
SQl Server Error:927 and Restoring

    Question

  • i have a problem with sharepoint database in SQL 2005.

    status of tow database in sql studio mamagment are restoring...

    how can i stop that? (change status to normal)

    AND SO :

    WHEN I GET A PROPERTISE OF THOSE DATABASE THIS ERROR APEAR:

    database cannot be openned. it is  in middle of restore. microsoft SQL server Error:927


    Sunday, June 07, 2009 4:54 AM

Answers

All replies

  • I SOLVE IT. I RESTORED AGAIN AND SUCCESSFULL AND COMPELETED.
    Sunday, June 07, 2009 7:05 AM
  • Jus as an FYI, there was no need to do the restore again. The probles was that the restore you did, you specified NORECOVERY. To get the database out of this state, you would just executin something like:

    RESTORE DATABASE dbname WITH RECOVERY
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
    Sunday, June 07, 2009 11:40 AM
    Moderator
  • I got the same problema related from ABBSA8786,

    And I can't retore my database....  executing RESTORE DATABASE dbname WITH RECOVERY...

    any thing else I can do to solve it ????

    Tuesday, October 20, 2009 12:53 PM
  • Do you get an error from executing that command? If so, please post - we need somethign work with with. Also please let us know some background (what happened, what you did etc).
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
    Tuesday, October 20, 2009 2:37 PM
    Moderator
  • TiborK

    I got the same thing.  What I did was an initial mistake and went like this

    had a db called "A", on Server-1
    asked to take a db called "Z" on Server-2, back it up, restore it to Server-1

    DUMB thing I did was NOT create the new DB first on Server-1.  I just restored it overtop another db, in this case "A" on Server-1.
    Realizing my mistake, I immediately, went to backups, restored to a point in time recovery on db "A", Server-1 and got the ERROR 927 !!

    NOW, Not sure how to resolve the ERROR 927:

    any help, please,
    Friday, October 23, 2009 6:44 PM
  • So you by mistale overwrote A on server 1 with a backup of Z from server 2? And you took an old backup of A and restored it on top if yout database A (possibly several restores including log restore), and the database A is now in restoring state? If so,

    RESTORE DATABAS A WITH RECOVERY


    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
    Saturday, October 24, 2009 8:03 AM
    Moderator
  • Hi Tibor,

    I am getting same error but here database is set to standby mode(logshipped), suggestion please..

    Error:

    database cannot be openned. it is  in middle of restore. microsoft SQL server Error:927


    TARAK

    Saturday, December 21, 2013 10:01 AM
  • Hi Tibor,

    I am getting same error but here database is set to standby mode(logshipped), suggestion please..

    Error:

    database cannot be openned. it is  in middle of restore. microsoft SQL server Error:927


    TARAK

    Hi Tarak,
    Did the restore complete? If there are no further backups to be restored then try below command

    RESTORE DATABASE <name_here> WITH RECOVERY





    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter
    Author: SQL Server 2012 AlwaysOn - Paperback, Kindle

    Saturday, December 21, 2013 10:24 AM
    Moderator