Monday, March 19, 2012

Backup database without touching tlog

Hi WWW
Is it possible to do full backup of the database without touching the
transaction log?
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.
Greetz
Steven.
Steven,
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
chain.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment