September 20, 2010 at 3:24 pm
GilaMonster (9/20/2010)
Or, if you don't want to believe me, how about someone who used to work on the storage engine team for SQL 2005.
Not that I don't believe you Gail, but thank you very much for that link (I think for me not to believe you I'd have to have the 800 pound gorilla sitting on my lap... :w00t: ) That is some in depth discussions... I have some reading to do, especially in the sublinks. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 20, 2010 at 3:25 pm
GilaMonster (9/20/2010)
SQL_Quest-825434 (9/20/2010)
The database involved in Logshipping should not be included in the manitenance plan as if you take a backup of it, it will break the log sequence.Instead use COPY_ONLY backup if you want to take backup of the primary database.
Full database backups DO NOT truncate the transaction log. They do not (and never have) broken the log sequence.
The only things that can break a log chain are a missing LOG backup (not full or differential), a switch to simple recovery or an explicit log truncation (backup log ... with truncate_only)
What COPY_ONLY does (for full backups) is not reset the differential base, so that further differential backups are not affected by a full database backup.
You can take full backups without affecting log shipping, without affecting log restore sequences. This has been true from at least SQL 7.
In addition to what Gail is saying is the eyeball test on it.
I have setup log shipping on terabyte databases. We did weekly fulls and nightly diff backups. Transaction logs were backed up and log shipped on a 15 minute basis. We never once had the full backup break the log chain - reason is just as Gail has explained.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply