Remove tail-log-backup-and-restore-in-sql-server
article thumbnail

Bootstrap PostgreSQL on Kubernetes

Percona

In this blog post, we will explore the immense value of provisioning PostgreSQL clusters with Percona Operator by using bootstrap capabilities: Start the cluster with init SQL script Bootstrap the cluster from the existing cluster or backup Getting started You need to have the Percona Operator for PostgreSQL deployed.

Storage 97
article thumbnail

The SQL Server Transaction Log, Part 1: Logging Basics

SQL Performance

All through my career as a data professional, both inside Microsoft and as a consultant, I’ve found one of the most misunderstood parts of a SQL Server database is the transaction log. Performance issues from repeated shrinking of the transaction log. Various issues around failovers and restore performance.

Servers 54
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

How It Works (It Just Runs Faster): Non-Volatile Memory SQL Server Tail Of Log Caching on NVDIMM

SQL Server According to Bob

Note: We received feedback that there was some confusion on us calling this functionality “tail of the log caching” because our documentation and prior history has referred to the tail of the log as the portion of the hardened log that has not been backed up. Create / Alter Database … LOG ON.

Cache 40
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. This White Paper is for informational purposes only. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40