Backups and Restoring states

• SqlGeek89

  Old Hand

  Points: 308

  More actions

  October 2, 2018 at 2:13 am

  #368915

  Hi 

  This morning i had a problem where my database was stuck in the restoring mode.

  I tried all of the T-SQL code with the recovery options and this did nothing got plenty of errors. The only thing that worked was restoring a database backup from 2009 which got rid of the restoring state other backups came back with errors before i tried this.

  I was just wondering how i can find out why this worked and the other didn't?

  This is all new to me so learning quickly.

  Thanks

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  October 2, 2018 at 7:12 am

  #2007671

  SqlGeek89 - Tuesday, October 2, 2018 2:13 AM

  Hi 

  This morning i had a problem where my database was stuck in the restoring mode.

  I tried all of the T-SQL code with the recovery options and this did nothing got plenty of errors. The only thing that worked was restoring a database backup from 2009 which got rid of the restoring state other backups came back with errors before i tried this.

  I was just wondering how i can find out why this worked and the other didn't?

  This is all new to me so learning quickly.

  Thanks

  What it worked and the others didn't would depend on what all of those errors were. We don't know what they were so really can only make wild guesses. Do you remember or did you save those errors and what was executed when you received those errors?

  Sue

• Brandie Tarvin

  SSC Guru

  Points: 173061

  More actions

  October 4, 2018 at 10:34 am

  #2008138

  Sue_H - Tuesday, October 2, 2018 7:12 AM

  SqlGeek89 - Tuesday, October 2, 2018 2:13 AM

  Hi 

  This morning i had a problem where my database was stuck in the restoring mode.

  I tried all of the T-SQL code with the recovery options and this did nothing got plenty of errors. The only thing that worked was restoring a database backup from 2009 which got rid of the restoring state other backups came back with errors before i tried this.

  I was just wondering how i can find out why this worked and the other didn't?

  This is all new to me so learning quickly.

  Thanks

  What it worked and the others didn't would depend on what all of those errors were. We don't know what they were so really can only make wild guesses. Do you remember or did you save those errors and what was executed when you received those errors?

  Sue

  It would also help if you associated your recovery options (what you did, GUI steps or full T-SQL code) for each attempt with each error.

  For example: RESTORE DATABASE XYX WITH RECOVERY; ended up with error "Database is FUBARed".

  Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.