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