Posted by Greg D. Moore \(Strider\) on 06/10/06 02:12

"Hugo Kornelis" <hugo@perFact.REMOVETHIS.info.INVALID> wrote in message
news:5hmi82pfl02iqnhelegm0v515dbdm1qpid@4ax.com...
> On 9 Jun 2006 02:35:01 -0700, Trevor Best wrote:
>
> (snip)
> >I want ot get a log from a client site onto my server for analysis but
> >I want ot make absolute certain that my backing up the log on their
> >server won't truncate it there.
>
> Hi Trevor,
>
> BACKUP LOG <databasename>
> TO DISK = 'x:\y\z\logbackup.bak'
> WITH COPY_ONLY;

Is this a SQL 2005 specific command? I've never seen it before.

Very handy.


>
> --
> Hugo Kornelis, SQL Server MVP

[Back to original message]