Re: Restore Log Terminates

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

From: Peter Yeoh (nospam_at_nospam.com)
Date: 10/01/04 

Date: Fri, 1 Oct 2004 09:26:36 +0800

> 1. You should have truncated the log between the Database backup and the
log backup

I think this should have been written as

1. You might have truncated the log between the Database backup and the log
backup 

-- 
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files?  Use MiniSQLBackup Lite, free!
"Hari Prasad" <HariPrasad@discussions.microsoft.com> wrote in message
news:1B3CE7FD-1D10-408C-9C58-1EAF11E1E34C@microsoft.com...
> Hi,
>
> 2 possibilities for this error,
>
> 1. You should have truncated the log between the Database backup and the
log
> backup
> 2. Missing a transaction log backup file.
>
> Please check both. You could investigate more using the backup history
> tables in msdb database.
>
> Thanks
> Hari
> MCDBA
>
>
>
>
>
> "Herb" wrote:
>
> > I'm trying to implement a scaled down version of log shipping by:
> >
> > 1. Backing up a database on server A and then restoring it to server B
> > (using WITH STANDBY).
> >
> > 2. Taking tranlog backups every 15 minutes from server A and then
restoring
> > them on server B (using WITH STANDBY).
> >
> > I take great pains to make sure that the tranlogs are restored in the
proper
> > order. However after a short period of time I get a message similar to
"the
> > log in this backup set begins at LSN xxx which is too late to apply to
this
> > database. An early log that includes LSN yyy can be restored."
> >
> > Can anyone tell me what I'm doing wrong here? I'd really appreciate the
help.
> >
> > Thanks, Herb
> >
> >

Relevant Pages

  • Re: Backup best practices...
    ... Worst case scenario for each of my customers ... if the server were to sit off for a week: They would use their offline files ... from the backup remote pop3 accounts (that we keep for when COX or SBC ... Try restoring to a new hard drive. ...
    (microsoft.public.windows.server.sbs)
  • Re: Restore SharePoint Server backup to New Server
    ... But here the problem is after restoring the database I am ... and configure SharePoint on the new server it will create a new config DB. ... I am having a problem while restoring the backup from old server to a new ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Unable to start Windows 2003 SBS after SP1 install
    ... After restoring the machine following Dave's excellent ... all future upgrades: ... Create a full backup or image of the server. ...
    (microsoft.public.windows.server.general)
  • Re: Disaster test - Windows Product Activation problem
    ... Are you restoring to different hardware than the original backup? ... > We are attempting to perform a Disaster Recovery TEST of our Windows ... > Small Business Server 2003 Std installation. ... > Microsoft document titled "Backing Up and Restoring Windows Small ...
    (microsoft.public.windows.server.sbs)
  • Import Frontpage backup to Portal Services?
    ... I'm having the same issue with trying to backup an ... existing site and restoring it to "re-brand" it for ... the greyed out server tools options? ... >been given a Frontpage backup .fwp file to load for a ...
    (microsoft.public.sharepoint.portalserver)