Stairway to TDE icon

Restore a Backup of a TDE Database to Another Server: Level 2 of the Stairway to TDE

In the second level of the stairway to TDE, we examine how you can restore your databases on another instance after moving the encryption certificate.

5 (3)

You rated this post out of 5. Change rating

2024-06-26 (first published: )

51,706 reads

SQLServerCentral Article

Advanced SQL Server installation using Powershell DSC

Introduction In the previous article, we learned how to install a SQL Server instance with basic parameters like InstanceName, Features, SourcePath, SQLSysAdminAccounts, etc using Powershell DSC. In this article, we'll discover how to enhance our SQL Server installation with additional configurations. We'll cover things like setting up service account credentials, custom installation directories, configuring TempDB […]

5 (3)

You rated this post out of 5. Change rating

2023-11-22

4,901 reads

Blogs

The Book of Redgate: Meetings

By

I think we might have forgotten this a bit, but on one of the...

New article: Automating SQL Server Builds

By

I refresh my test SQL Servers at least monthly with a fresh VM. Setting...

Leading with Accountability: How Extreme Ownership Transforms Leadership

By

Embracing Total Responsibility In every organization there comes a moment when teams must choose...

Read the latest Blogs

Forums

What Makes a Blockchain Development Company Essential for Modern Businesses?

By vegavidtech

A blockchain development company helps businesses leverage decentralized technology to improve transparency, security, and...

How to resolve issue of custom Audit log table containing incorrect data?

By Kevin8

We have created a parent table, child table & Audit log table in SQL...

Change Tracking Default Retention

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Change Tracking Default Retention

Visit the forum

Question of the Day

Change Tracking Default Retention

I run this command on my SQL Server 2022 database:

ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;
What is the default data retention period?

See possible answers