The Table Backup

Question

The Table Backup

Steve Jones - SSC Editor

SSC Guru

Points: 737673
More actions
March 24, 2025 at 12:00 am

#4511053

Comments posted to this topic are about the item The Table Backup

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Carlo Romagnano SSC-Insane Points: 22737 More actions · Answer 1

uhm, what about "Temporal tables"?

"Temporal tables" do not need to be backed up and restored, you can see values in the "past" and restore them with a query.

"SQL Server 2016 (13.x) and later versions"

This reply was modified 4 weeks, 1 day ago by Carlo Romagnano.

Jeff Moden SSC Guru Points: 1004577 More actions · Answer 2

Carlo Romagnano wrote:

uhm, what about "Temporal tables"?
"Temporal tables" do not need to be backed up and restored, you can see values in the "past" and restore them with a query.

So drop a temporal table (along with its history table) without it being backed up as a part of the database backup and let's see you recover it. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 737673 More actions · Answer 3

I'm not sure what temporal tables have to do with this. BACKUP TABLE reports as not implemented.