• Skip to main content
  • Skip to primary sidebar

DallasDBAs.com

SQL Server Database Consulting

  • Services
    • SQL Server Health Check
    • Fractional DBA
  • Pocket DBA®
  • Blog
    • Speaking
  • Testimonials
  • Contact
  • About

video

Do Full Backups Break Log Shipping?

October 15, 2021 by Kevin3NF Leave a Comment

TLDR: Nope.

A tub boat pushing logs down a river
Image by jakeforlove from Pixabay

Keep on doing your full backups.

Make sure that any databases you Log Ship are NOT also doing log backups in your SQL Maintenance Plans, Ola Jobs, etc.

The Backup Chain will not be broken by running a Full backup, and you do not need to use Copy-Only

Proof:

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs

Filed Under: backup, SQL Tagged With: syndicated, video

Renaming SQL Server Databases

October 12, 2020 by Kevin3NF Leave a Comment

Video walkthrough of renaming or “flipping” databases to minimize down time during a refresh.  Most commonly when moving a copy from prod to dev.

My Pluralsight courses for new SQL Server DBAs

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs

Filed Under: SQL, video Tagged With: syndicated, video

Primary Sidebar

Search

Sign up for blogs, DBA availability and more!

Home Blog About Privacy Policy
  • Home-draft
  • Blog
  • About Us

Copyright © 2025 · WordPress · Log in

 

Loading Comments...