Re: Database recovery with data file only

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 06/30/04 

Date: Tue, 29 Jun 2004 19:41:37 -0600

There are many approaches that seem "easier and faster" but
they aren't necessarily good ideas and can actually not
really be "easier and faster" in the long run.
Note Paul's response. I remembered that Sybase used to (or
still does, I don't know) have the command and if it failed
once or twice, you essentially ended up with a useless data
file and couldn't execute the command anymore. There are
even easier sql commands posted up here that users have
problems getting right the first or second time - and all of
us have had those days where typing a simple select doesn't
work. For those reasons, it's probably better for a user to
call support and have someone from PSS walk them through the
process carefully. Ever since it's been posted on
newsgroups, I've seen it abused and misused by companies.
If they end up with nothing but a useless data file, it may
have actually have been "easier and faster" for them to get
the backups read off the failed media from a company that
specializes in that and restore the database from those
files.

-Sue

On Tue, 29 Jun 2004 18:46:10 +0530, "Hari"
<hari_prasad_k@hotmail.com> wrote:

>Hi Dan,
>
>I accept what you say regarding data integrity.
>I suggested /recommended this method only because ken do not have the
>database Backup as well as
>no LDF files. In this case DBCC REBUILD_LOG will be a easy and faster
>approach. After bringing
> up the database ken can execute a DBCC CHECKDB and confirm that database is
>fine or not.

Relevant Pages

  • Re: DBCC error 913
    ... Something's definitely screwed up as database IDs can't go that high. ... I am running DBCC Checkdb with repair_rebuild option. ... Microsoft SQL Server Storage Engine ... >>> Then I run the command sp_dboption dbname,'Single user',true also. ...
    (microsoft.public.sqlserver.server)
  • Re: Windows Update Services-SUSDB CHECKDB CHECKCATALOG
    ... osql -S.\WSUS -E ... This approach will require that you set the database in SINGLE USER mode so ... After executing the DBCC CHECKDB command, ...
    (microsoft.public.windows.server.sbs)
  • Re: DBCC error 913
    ... I am running DBCC Checkdb with repair_rebuild option. ... on the database manually it is not giving any error. ... >> this command runs inside a cursor and DBCC checkdb commands starts after ...
    (microsoft.public.sqlserver.server)
  • RE: Event ID 447
    ... Please made a backup for Exchange database first. ... Please run the eseutil /mh command to see if the mailbox store is clean ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint Database falling over event 1000
    ... Microsoft Small Business Server Support ... > I Have Just run the SQL command from the command Line, ... > affected)1> exitDoes this say the database is Ok?If so why since we loaded ... > I/O operation has been aborted because ofeither a thread exit or an ...
    (microsoft.public.windows.server.sbs)