Wednesday, December 4, 2013

Working on re-configuring SQL Server Maintenance Plans responsible for full, differential, and transaction log backups, database consistency checks, file clean-up operations, etc.  One of the key questions has been trying to evaluate the impact of running transaction log backups during full or differential backups.  The first link is to an article that addresses this question.  The additional links are links to additional articles on backups, restores, etc.

http://www.sqlskills.com/blogs/paul/search-engine-qa-16-concurrent-log-and-full-backups/

http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-3030-backup-myths/

http://www.sqlskills.com/blogs/paul/misconceptions-around-the-log-and-log-backups-how-to-convince-yourself/

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/7d4947a4-a1be-46af-bb76-aa62c7011e63/full-and-transaction-log-backup-sequence-question?forum=sqldisasterrecovery

http://technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx

No comments:

Post a Comment