September 16, 2003 at 8:51 am
I've written some log shipping code to run between 2 of my servers. Each night a full copy of the database is copied over and applied. Throughout the day I have my logs copying over at half hour intervals.
My question is - what advantage is there to copying the full backup each night? Would there be any implications if I merely continued to copy the transaction logs?
cheers
September 16, 2003 at 7:17 pm
Hi there
Saftey more than anything, I would continue doing it to ensure maximum flexibility if, for whatever reason, you do need the full again. How big is the DB?. In the Oracle world, its known a duplexing your backups, and at all times you should think saftey first, otherwise you will loose your DBA job faster than you got it... well maybe not, but it aint worth the risks.
Cheers
Ck
(bread and butter dba)
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 17, 2003 at 5:20 am
Is the log shipping copy of the database just for disaster recovery?
If so, I wouldn't bother with the full copy each night. If anything happens to your DR copy, you can re-initialise from the latest full backup.
We have some very large databases that are log shipped for DR purposes, and have been log shipping for months without re-initialising the DR copy.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply