SQL Database Corrupt (how to restore backup?)

Topics related to MLServer 4
jeffdoo
Intermediate
Intermediate
Posts: 329
Joined: Sat Aug 25, 2007 9:19 pm
Location: Huntersville, NC
Contact:

SQL Database Corrupt (how to restore backup?)

Postby jeffdoo » Sat Jul 30, 2016 3:42 pm

Dave,

Apparently disaster struck while we were out of town on vacation... The SQL database "master" has become corrupt and SQL Server is unable to start, hence MLS is unable to start.

Code: Select all

An error occurred during recovery, preventing the database 'master' (database ID 1) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.


As I left the system at the default (I believe) of 7 days of backups, how can I restore the database?

Code: Select all

 Directory of C:\Program Files (x86)\Cinemar\MLServer\Backups

07/24/2016  12:01 AM    <DIR>          .
07/24/2016  12:01 AM    <DIR>          ..
07/18/2016  12:00 AM        82,251,776 Cinemar_db_7-18-2016 12.00.07 am.bak
07/19/2016  12:00 AM        82,317,312 Cinemar_db_7-19-2016 12.00.16 am.bak
07/20/2016  12:00 AM        82,317,312 Cinemar_db_7-20-2016 12.00.25 am.bak
07/21/2016  12:00 AM        82,317,312 Cinemar_db_7-21-2016 12.00.05 am.bak
07/22/2016  12:00 AM        82,317,312 Cinemar_db_7-22-2016 12.00.14 am.bak
07/23/2016  12:00 AM        82,251,776 Cinemar_db_7-23-2016 12.00.23 am.bak
07/24/2016  12:00 AM        82,317,312 Cinemar_db_7-24-2016 12.00.32 am.bak
07/18/2016  12:00 AM        12,340,507 HTML_7-18-2016 12.00.10 am.zip
07/19/2016  12:00 AM        12,340,507 HTML_7-19-2016 12.00.19 am.zip
07/20/2016  12:00 AM        12,340,507 HTML_7-20-2016 12.00.29 am.zip
07/21/2016  12:00 AM        12,340,507 HTML_7-21-2016 12.00.08 am.zip
07/22/2016  12:00 AM        12,340,507 HTML_7-22-2016 12.00.17 am.zip
07/23/2016  12:00 AM        12,340,507 HTML_7-23-2016 12.00.25 am.zip
07/24/2016  12:00 AM        12,340,507 HTML_7-24-2016 12.00.35 am.zip
07/18/2016  12:01 AM       326,524,758 Images_7-18-2016 12.00.10 am.zip
07/19/2016  12:01 AM       326,524,758 Images_7-19-2016 12.00.19 am.zip
07/20/2016  12:01 AM       326,524,758 Images_7-20-2016 12.00.29 am.zip
07/21/2016  12:01 AM       326,524,758 Images_7-21-2016 12.00.08 am.zip
07/22/2016  12:01 AM       326,524,758 Images_7-22-2016 12.00.17 am.zip
07/23/2016  12:01 AM       326,524,758 Images_7-23-2016 12.00.25 am.zip
07/24/2016  12:01 AM       326,524,758 Images_7-24-2016 12.00.35 am.zip


Thanks!

- Jeff

User avatar
CinemarDave
Site Admin
Site Admin
Posts: 10535
Joined: Fri Feb 07, 2003 8:56 am
Location: Planet Earth
Contact:

Re: SQL Database Corrupt (how to restore backup?)

Postby CinemarDave » Mon Aug 01, 2016 10:41 am

Jeff, the quickest way back is to install SQL Management Studio and manually install one of the previous backups from the list of saved backups. I can remote in and quickly have a look. Send me your current TeamViewer info.

jeffdoo
Intermediate
Intermediate
Posts: 329
Joined: Sat Aug 25, 2007 9:19 pm
Location: Huntersville, NC
Contact:

Re: SQL Database Corrupt (how to restore backup?)

Postby jeffdoo » Tue Aug 02, 2016 1:59 pm

CinemarDave wrote:Jeff, the quickest way back is to install SQL Management Studio and manually install one of the previous backups from the list of saved backups. I can remote in and quickly have a look. Send me your current TeamViewer info.


Dave,

Something went drastically wrong earlier today and Windows 10 was unable to boot or fix itself. I ended up restoring the 7/24 backup and selectively restoring the data from other components (ie; weather station, sprinklers, etc). Right now everything appears to be back and properly running...

Thanks for the offer to help with MS SQL Server.

- Jeff


Return to “MLServer 4”

Who is online

Users browsing this forum: Bing [Bot] and 2 guests