Backup database without touching tlog - 02-17-2006 , 04:16 AM
Is it possible to do full backup of the database without touching the
And if this is possible how to do ?
We want to do some log shipping but I want to keep to do a full backup of
the live database ... otherwise we must switch our backup device from
live-server to standby-server to do full backup on standby-server !
( using sql 2000 std ed )
Thank you for your time and reply.
Re: Backup database without touching tlog - 02-17-2006 , 04:49 AM
the full database backup has little to do with the log. Check out "BACKUP
DATABASE" in BOL - doing a full backup doesn't affect the log-shipping
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book: