Prev: SQL2K Agent Job Steps
Next: A Question about SQL Server 2008 Installation
From: Tibor Karaszi on 9 Mar 2010 12:42
> There's also a potentially useful feature of SQL Server 2005 called
> "Copy-only backup".

Absolutely. However, there's a myth going on "out there" that this is
somehow useful or even necessary when you do db backup, so the db backup
doesn't break log backup sequence. This is not the case. It doesn't hurt to
set it for this scenario, it is just a no-op. The two scenario where
COPY_ONLY can be useful are:

BACKUP DATABASE ... COPY_ONLY:
If you do db and diff backup and you want to do a ("out-of-band") db backup
without affecting your diff backups.

BACKUP LOG ... COPY_ONLY:
If you do log backups and want to do a log backup without truncating the log
(affecting your "normal" log backup sequence).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"Gerry Hickman" <gerry666uk2(a)newsgroup.nospam> wrote in message
news:eiWAyc6vKHA.3408(a)TK2MSFTNGP06.phx.gbl...
> "Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> wrote
> in message news:uaIQ2spvKHA.812(a)TK2MSFTNGP06.phx.gbl...
>> Nothing. A full backup do not break the log backup chain. Or, to phrase
>> it differently, a full backup doesn't truncate the log.
>
> There's also a potentially useful feature of SQL Server 2005 called
> "Copy-only backup". This allows you to create a backup for a special
> purpose without affecting the usual backup sequence.
>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>>
>>
>> "Patrick" <Patrick(a)discussions.microsoft.com> wrote in message
>> news:#JtkOOpvKHA.1796(a)TK2MSFTNGP02.phx.gbl...
>>> We are running daily database backup and transaction log backup every
>>> hour.
>>>
>>> We would like to know if we make a full backup mid way the day (Like:
>>> 12:20pm), can we still be able to restore point in time to a time before
>>> that full backup (Like: restore from last night backup and transaction
>>> log backup to 11:15am) ?
>>>
>>> Thanks
>>
>
First  |  Prev  | 
Pages: 1 2
Prev: SQL2K Agent Job Steps
Next: A Question about SQL Server 2008 Installation