Re: Remote restore question

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 16:24:34 -0500

You can restore logs in sequence on a SQL 7.0 or 2000 and ignore intervening
full backups. This is intentional so that if a full backup goes bad, you
can go to an older full backup and restore more logs to get your database up
to the last committed transaction.

BTW, this is called log-shipping. SQL enterprise edition includes it as
built-in, but many people write their own routines to handle situations and
configurations not directly supported but the built-in tools. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"sqlboy2000" <sqlboy2000@hotmail.com> wrote in message
news:49e85cd3.0403171311.6b65aab4@posting.google.com...
> Hello everyone,
> Quick question. We perform db backups at 10pm on a certain database
> that is about 12 gig. Then the transaction log is backed up every
> hour. We'd like to restore this database to another off site server,
> then apply the logs to keep it in sync w/ production. I've tested this
> and it seems to work fine. My only question is regarding the full
> backups that are performed every night. Due to bandwidth limitations,
> we can't get the full db backup to the remote server in a reasonable
> amount of time (the logs can make it over within one hour no problem).
> Can we just keep restoring the logs on the remote server without the
> nightly db backups being restored? I guess I'm asking if the full db
> backup does anything to the log (empties it or the like) that would
> make the dbs out of sync?
>
> Thanks in advance.

Relevant Pages

  • Re: Transaction Logs
    ... > SoftwareVendorId INTEGER, ... >> When restoring is there a way to restore all the logs in one statement. ...
    (microsoft.public.sqlserver.programming)
  • Re: BCVs on a cluster
    ... option to bring the restore in a state where you can roll-forward the logs. ... that BCV may not be used as the starting point for further log restores; ... If you are running EMC storage, please have a look at the Timefinder SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: restoring a portal
    ... > If you are using SQL Server as the Database back end, ... > existing Databases assocoated with Portal, ... > SQL backups running you could also try to restore fro SQL also. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: How Safe are Backups?
    ... The only thing I would add is that I haven't had a restore fail for me and I ... The stsadm backups seem to utilize a fair amount of disk ... we do SQL backups as well. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Re-Configure path to "Root Directory" ?
    ... moving any one of those types of files to another location. ... Basically the easiest one to move should be your database backups. ... To move your data and logs for your databases refer to the following KB ... Need SQL Server Examples check out my website at ...
    (microsoft.public.sqlserver.server)
Loading