Friday, March 23, 2012

Power went out -- how to check consistency, etc.?

The power went out to a live SQL Server. UPS was being serviced (that
figures) and thus the server simply lost all power. Now what?
How do I check for consistency?
Will checking consistency take the database down (like some dbcc things)?
What else should I do/check?DBCC CHECKDB and DBCC CHEKCATALOG are what you want to run. By default they
are online operations. But I would want to know if there is damage or
corruption before I even let someone back in if possible.
Andrew J. Kelly SQL MVP
"HK" <replywithingroup@.notreal.com> wrote in message
news:7YFLf.472$xS5.132@.tornado.socal.rr.com...
> The power went out to a live SQL Server. UPS was being serviced (that
> figures) and thus the server simply lost all power. Now what?
> How do I check for consistency?
> Will checking consistency take the database down (like some dbcc things)?
> What else should I do/check?
>|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.server:425005
Traffic came back on its own when the system restarted. So too late to run
the check first. By "online", do you mean they will NOT interrupt live
transactions when I run them? (BOL doesn't really say). Also, which
repair option do you think I should use if it finds something?
REPAIR_ALLOW_DATA_LOSS or REPAIR_REBUILD
(assume I want good repairs and not fast ones)
Thanks
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%233R4L%23WOGHA.1216@.TK2MSFTNGP14.phx.gbl...
> DBCC CHECKDB and DBCC CHEKCATALOG are what you want to run. By default
they
> are online operations. But I would want to know if there is damage or
> corruption before I even let someone back in if possible.
> --
> Andrew J. Kelly SQL MVP
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:7YFLf.472$xS5.132@.tornado.socal.rr.com...
things)?[vbcol=seagreen]
>|||Repair_Rebuild is pretty safe and any errors fixed by that should be fine.
If it doesn't fix some you may have to run with the allow data loss. But
obviously that has the potential to loose data and you won't know which is
lost. So if it comes down to that it is always recommended to restore from
your last known good backups.
Andrew J. Kelly SQL MVP
"HK" <replywithingroup@.notreal.com> wrote in message
news:eXILf.83$8l2.0@.tornado.socal.rr.com...
> Traffic came back on its own when the system restarted. So too late to
> run
> the check first. By "online", do you mean they will NOT interrupt live
> transactions when I run them? (BOL doesn't really say). Also, which
> repair option do you think I should use if it finds something?
> REPAIR_ALLOW_DATA_LOSS or REPAIR_REBUILD
> (assume I want good repairs and not fast ones)
> Thanks
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%233R4L%23WOGHA.1216@.TK2MSFTNGP14.phx.gbl...
> they
> things)?
>

No comments:

Post a Comment