Re: Log File Backup and Log Shipping

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 03/21/05 

Date: Mon, 21 Mar 2005 09:51:31 -0500

Log shipping will include ( and become, and replace ) your log backup. 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Patricia" <Patricia@discussions.microsoft.com> wrote in message 
news:1512FBDF-8A4B-4FF8-9092-5C2DBC377EC1@microsoft.com...
> Dear All,
> We currently back up our log file every 10 minutes.
>
> We now have a requirement to implement log shipping. My question however 
> is
> will this effect out Log File Backup, such that together they will not 
> work
> correctly ?
>
>
>

Relevant Pages

  • Re: Standby server - with no data loss
    ... The closest you can get is Log Shipping at 1 minute intervals. ... Database mirroring which will be 100% point in time correct. ... Mike Epprecht, Microsoft SQL Server MVP ... you're only other fail-safe is the backup strategy. ...
    (microsoft.public.sqlserver.server)
  • Re: Slow performance after restarting
    ... Columnist, SQL Server Professional ... Launch additional instances of Query Analyzer and verify the connection ... Detach/Rename/Re-attach gets me a much smaller transaction ... >> log file is this size or what you do for backups. ...
    (microsoft.public.sqlserver.programming)
  • Re: Transaction Log Failure
    ... A maintenance plan can not create a log file, ... then bring up sql server. ... > maintenance plan that would create a transaction log file every hour. ... > 2004-12-14 21:00:43.51 backup BACKUP failed to complete the command ...
    (microsoft.public.sqlserver.server)
  • Re: Slow performance after restarting
    ... without the hotfix but the problem disappeared when the hotfix ... Columnist, SQL Server Professional ... Launch additional instances of Query Analyzer and verify the connection ... >> log file is this size or what you do for backups. ...
    (microsoft.public.sqlserver.programming)
  • Re: The location of transaction log file
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > log file of existing database? ... >>> How to change the location of transaction log file of existing ... >>> database files into two different drives. ...
    (microsoft.public.sqlserver.server)