Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jcheng
Starting Member
5 Posts |
 Posted - 2008-09-05 : 18:10:52
|
| I'd like to setup log shipping on my SQL Server 2005, as well as daily full backup of the primary database. Will full backup on the primary database interfere with log shipping? Do I have to do a COPY_ONLY full backup instead on the primary database?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-05 : 18:14:38
|
| Full backups do not interfere with log shipping. But when you setup log shipping, it'll create full backup and transaction log backup jobs on the primary server. So you don't need to do any full backups outside of the log shipping plan.You don't need to do COPY_ONLY either.Note: Never perform a transaction log backup on the primary database outside of the log shipping jobs unless you are going to manually apply it to the secondary database. This is what interferes with log shipping as it'll break the transaction log backup chain if you don't manually apply it.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
jcheng
Starting Member
5 Posts |
Posted - 2008-09-05 : 18:40:00
|
Thanks for your quick respond. Does the database backup (.bak) and tlog backup (.trn) on the primary server get deleted after a specific time period? I thought there was a setting - delete files older than certain days - when configuring log shipping and there is no way to turn it off.Anyway, my intention to do a daily full backup in addition to log shipping in order to provide an extra layer of redundancy. Thanks again  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Log Shipping and Daily Backup