Geek Answers Handbook

How does backup work on SQL server?

Say I have a very large database. His backup starts at midnight and ends at 02:00.

When I restore this backup, will I have the database state at midnight or 02:00 (or something else)?

Following another step, let's say that I have several databases that contain links to each other's elements. If I simultaneously back up all the databases in parallel, when I restore them, will I have the state of all the databases at the same time?

+5
source share
1 answer

The backup process in SQL Server backs up the data files and parts of the transaction log, so this will be the state of the database at 2 a.m.

You can guarantee the consistency of transactions between the databases if the backup stops exactly at the same time. This is probably not what you want to rely on, so I would recommend using frequent backups of transaction logs in addition to any overnight full strategy that you use.

+6
source

More articles:


All Articles