Re: dbcc repair_allow_data_loss

From: Paul S Randal [MS] (prandal_at_online.microsoft.com)
Date: 05/04/04 

Date: Mon, 3 May 2004 18:41:34 -0700

> Just to be sure: You mean, that it's possible that data is lost and we do
not have any information about this in the Log-File of the repair job?

I'm not sure what's captured in the log file but DBCC always provides
output.

> So, what would you suggest if we'll find consistency errors again (with
the suggestion repair_allow_data_loss)?

I would suggest you have a hardware issue if you see it again - in fact, I'd
suggest you do root-cause analysis to make sure you hardware is sound anyway
just because you saw this corruption.

> Go back to the last complete backup? (lose 24 h work of the users)!
> Have a system downtime and try to repair the database?
>
You should always be able to restore from your backups - repair should
always be a last resort. How often you take them is up to you - you must ask
yourself 'how much data can my business afford to lose?'. If the answer is
zero, then you need to beef up your backup strategy and put in place a
disaster recovery strategy (maybe use clustering, log shipping etc). I've
seen catastophic failures where the loss has only been 15 minutes or less
with a daily full backup and log backups every 15 mins.

Regards. 

-- 
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"skrampe" <anonymous@discussions.microsoft.com> wrote in message
news:73BA7F69-450B-4CE9-8C7C-1D8DDB0F10AF@microsoft.com...
> ...
> You should assume that
> data was lost if you had to use this option and so your business or
> application logic may no longer be correct (constraints etc).
> ....
>
> Just to be sure: You mean, that it's possible that data is lost and we do
not have any information about this in the Log-File of the repair job?
>
> We check our database every night.
> So, what would you suggest if we'll find consistency errors again (with
the suggestion repair_allow_data_loss)?
>
> Go back to the last complete backup? (lose 24 h work of the users)!
> Have a system downtime and try to repair the database?
>
> Thank you very much for your help!
>
> Regards,
>
> Sven Krampe
>
>

Relevant Pages

  • Re: Safe to do XP Repair without backing up files?
    ... Repair and finding it caused documents, ... pictures or movie files to be lost. ... I cannot give you 100% assurance you will be alive to read this, ... tells me that more than likely - no backup has ever been ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Safe to do XP Repair without backing up files?
    ... No one can give you 100% assurance that your friend's files won't be lost or damaged, even if you never attempt to repair his computer. ... There is a plethora of backup software and backup devices. ... a repair install of Windows XP only affects Windows system files and has no effect on a user's files if done properly. ... Just wondering if anyone has any horror stories about doing an XP Repair and finding it caused documents, pictures or movie files to be lost. ...
    (microsoft.public.windowsxp.perform_maintain)
  • RE: Access programming gone
    ... Make a backup and try to repair your Db whit Access tools. ... i lost a few Db trying to repair it:) ... "Dan" wrote: ...
    (microsoft.public.access.modulesdaovba)
  • Re: linked table problem and need advice
    ... I'd run the Compact and Repair a few more times to ... ALWAYS WORK ON A BACKUP COPY. ... only lost x hours of work) ...
    (microsoft.public.access.gettingstarted)
  • Re: Domain Controller Stops Processing All Login Requests Randomly
    ... I backup the DCs and a few other servers using ... the grandfather-son-grandson backup scheme so not to worry on that, ... >> be after a repair. ... DCs that have died or been uninstalled. ...
    (microsoft.public.windows.server.dns)