none
SQL 2012 RESTORING STATUS

    Question

  • Hi,

    How can we fix the RESTORING status on SQL Server 2012. The scenario is we dont have .bak file the only file that we have is .mdf and log file? can someone help us on our issue.

    Monday, March 20, 2017 12:45 PM

All replies

  • Depending on how your database got to this stage you might be able to do this

    restore database DatabaseName with recovery

    This will work if you did a tail log backup or if your database was part of a log shipping topology.

    Can you give us any details on how this database got this way?

    Monday, March 20, 2017 12:47 PM
  • Hi Iamdrino,

    Try using this script: 

    RESTORE DATABASE [DataBase Name] WITH RECOVERY;

    Thanks,

    Gina

    Monday, March 20, 2017 12:52 PM
  • Hi,

    How can we fix the RESTORING status on SQL Server 2012. The scenario is we dont have .bak file the only file that we have is .mdf and log file? can someone help us on our issue.

    If you mean restoring state that means database is being restored either from backup or is participating in mirroring or logshipping. Can you check that please

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Monday, March 20, 2017 1:34 PM
    Moderator
  • the scenario is we remove the always on, then after that removing the fail over clustering after that the db goes to Restoring status
    Tuesday, March 21, 2017 1:13 AM
  • This is "by design". The restore command will likely not work. You need to restore from a backup taken recently on the primary.
    Tuesday, March 21, 2017 1:19 AM