|
Posted by Hugo Kornelis on 06/09/06 11:25
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;
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|