Skip to content
WickTech Blog
Thoughts on SQL Server, PowerShell, and excursions with a Canon camera
  • About
  • Posts
  • Blog Roll
  • Presentations
  • Photo Gallery
  • Contact

Tag: database maintenance

Backup On-Prem SQL Databases to Azure

2019-04-16 Jamie 1 Comment

Azure storage, as a backup destination for SQL backups, is a great option for organizations that are contemplating replacing older…

Continue Reading →

Posted in: Azure, SQL Server Filed under: Azure, Azure Storage, backups, database maintenance, SQL Credential

Are Differential Backups Necessary?

2019-04-02 Jamie 1 Comment

SQL Server natively supports 3 types of backups: Full, Differential and Log. Full backups take a complete backup of the…

Continue Reading →

Posted in: SQL Server Filed under: database maintenance, Differential, recovery, Restore, restore process, SQL Server, stopat

Monitoring Virtual Log File Information

2019-01-02 Jamie 1 Comment

Monitoring transaction log usage is an important part of database maintenance. High numbers of Virtual Log Files (VLFs) within a…

Continue Reading →

Posted in: SQL Server Filed under: database maintenance, DBCC, Transaction Log, Virtual Log File, VLF Count, VLF Stats

Log Backups, Auto Growth Settings, & Alerts (Part 1)

2018-07-09 Jamie 1 Comment

Why does missing a few log backups matter? I was asked that question last week when one of our backup…

Continue Reading →

Posted in: SQL Server Filed under: backups, configure, database maintenance, growth setting, SQL Server

Categories

Connect with

  • LinkedIn
  • Twitter
Tweets by Jamie_Wick
Copyright © 2023 WickTech Blog
 

Loading Comments...