Skip to content

SQL Nuggets

Nuggets Of SQL Server Knowledge

Menu
  • Home
  • Blog
  • Speaking
  • Presentations
  • Downloads
  • About

Category: Backups

Backups / PowerShell

Backing Up Databases With The dbatools PowerShell Module

Posted on November 20, 2019November 20, 2019 by Eric Cobb

We do a lot of database backups and restores at work, outside of our regular backup routines. A lot! I’ve actually done as many as 40 in one day. Our …

Backups / Corruption / DB Engine / Errors

Corruption With Backup Compression And TDE In SQL 2017

Posted on January 16, 2018January 16, 2018 by Eric Cobb

Last week I spent a good bit of time dealing with a corruption issue, and as it turns out I may actually have found a bug in SQL Server 2017.  …

Backups / Corruption / Errors / SQL Scripts

SQL Scripts: How To Make Sure Your Backup Is Valid

Posted on November 1, 2017January 16, 2018 by Eric Cobb

I recently had a case where I needed to download a database backup to my laptop.  It usually takes about 12 hours for this particular backup to copy down, so …

Backups / SSIS

Resolving Write Error When Backing Up Database Master Key

Posted on July 5, 2016July 5, 2016 by Eric Cobb

This blog post is more for my own personal notes so that I don’t bang my head against the wall so much next time, but hopefully it will help someone …

Backups

Using Ola Hallengren’s SQL Server Maintenance Solution with SQL Server Express Edition

Posted on July 7, 2015 by Eric Cobb

This post is just a quick extension of my earlier post on Automating backups for SQL Server 2008 R2 Express Edition.  If you’d rather use Ola Hallengren’s SQL Server Maintenance …

Backups

Automating backups for SQL Server 2008 R2 Express Edition

Posted on June 9, 2015July 7, 2015 by Eric Cobb

One of the limitations of SQL Server Express is that you can’t automate backups in it via the SQL Server Agent like you can the other versions of SQL Server. …

2020 IDERA ACE
MSCE: Data Platform

Search

Subscribe via Email

Receive notifications of new posts by email.

SUBSCRIBE VIA RSS

RSS Feed RSS - Posts

Categories

  • Availability Groups
  • Azure
  • Backups
  • Career
  • Conferences
  • Configurations
  • Corruption
  • DB Engine
  • Errors
  • Extended Events
  • Indexes
  • Management
  • MongoDB
  • Monitoring
  • Open Source Projects
  • PowerShell
  • Security
  • SQL Scripts
  • SSIS
  • System Views
  • T-SQL
  • Tools

Recent Posts

  • Backing Up Databases With The dbatools PowerShell Module
  • 2020 IDERA ACE
  • Recover Deleted Indexes With SQL Server Metrics Pack
  • SQL Server Metrics Pack Update – September 2019
  • SQL Scripts: Find Queries That Have Missing Index Requests

Top Posts

  • SQL Scripts: How To Find Missing Indexes
  • SQL Scripts: How To Find Index Fragmentation
  • SQL Scripts: How To Check Logins And Permissions
  • Using PowerShell To List Folders And Sizes
  • Checking The Status Of Email Sent From SQL Server

Tags

Automation Azure Migration Backups Bad T-SQL Client Tools Clustered Indexes Database Mail Database Maintenance Data Files Data Storage dbatools DBCC CheckDB Encryption Execution Plans Express Edition Getting Started Index Basics Internals Log Files Music City Data NOLOCK Nonclustered Indexes NoSQL Performance Permissions Presentations Quickies Server Administration Speaking SQL Agent SQL Index Insight SQL Metrics Pack SQL Permissions Manager SQL Saturday SQL Sentry SQL Server 2008 R2 SSMS Storing Passwords System Procedures Top Developer Tips Trace Flags Transaction Isolation Levels Visual Studio
Copyright © 2019 SQL Nuggets – OnePress theme by FameThemes
This website uses cookies to improve your experience. To find out more see our Privacy & Cookies Policy. Accept
Privacy & Cookies Policy

Necessary Always Enabled