The Table Backup
-
Comments posted to this topic are about the item The Table Backup
-
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"
- 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) -
I'm not sure what temporal tables have to do with this. BACKUP TABLE reports as not implemented.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply