Re: Crash Recovery

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 22:10:46 +0100

You can't apply an LDF file to a restored database backup. If you're lucky,
you might be able to dig something out of the LDF file using some log reader
program. See my signature, the links. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Bob Morris" <bmorris@kenyaonline.com> wrote in message
news:eiZLHtfBEHA.2768@tk2msftngp13.phx.gbl...
> Thanks, but what I need is to try and apply the LDF after I restore the
> backup.
>
> Regards
>
> "Hari" <hari_prasad_k@hotmail.com> wrote in message
> news:eAF4v9cBEHA.3568@tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Since the MDF file is not avaible you will not able be use the LDF.
> > But using DATA.BAK file you can recover the database back to the time in
> > whcih backup is created.
> >
> > How to restore the BAK file.
> >
> > From Query analyzer execute the below command
> >
> > 1. Copy the DATA.BAK to c:\backup folder
> >
> >     Restore database <dbname> from disk='c:\backup\data.bak'
> >
> > You may need to use WITH Move option along with restore statement.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> >
> >
> >
> > "Bob Morris" <bmorris@kenyaonline.com> wrote in message
> > news:#fVLgrcBEHA.3348@TK2MSFTNGP11.phx.gbl...
> > > I am trying to restore a crashed server. The server has an SQL2K
> > > installation with a small database (say)  DATA. The file DATA.MDF has
> gone
> > > missing during the crash. The file DATA.LDF has been recovered. There
is
> > > also a backup file DATA.BAK. This backup is about 4 MB and I suspect
it
> > was
> > > used to install the database in the first place, as it is several
months
> > > old. The log file LDF has been recently updated and is 47 Mb.
> > >
> > > Is there any way to recover this database to a reasonable up to date
> > version
> > > using DATA.BAK and DATA.LDF. All suggestions are welcome?
> > >
> > > Bob
> > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: POINT IN TIME RESTORE
    ... This is what you should have done in order to do the restore as you wish: ... > 3- erase data ... > 5- restore database with norecovery ... The BACKUP DATABAE can of course be at an earlier point in time, ...
    (microsoft.public.sqlserver.server)
  • RE: How to restore edb & stm files from bkf backup file on another exc
    ... copied to a different storage group on the same server or to a different ... On production server successfully backup information ... Restore Status ... Failed to find a database to restore to from the Microsoft ...
    (microsoft.public.exchange.admin)
  • Re: Transaction Log ??
    ... we used to simplify our database restore process: ... every database got their respective backup folder. ... -- get logFileName, FirstLSN, LastLSN list ...
    (microsoft.public.sqlserver.security)