August 21, 2008 at 4:55 pm
Hi,
Suppose we have a big database like 400-500 GB, What will be the state of a database while we are taking a backup (full or transaction log) considering that backup will take considerable amount of time. Will the users be able to access (read/write/update/delete) the database?
August 21, 2008 at 5:03 pm
Access to the database can continue as normal.
August 21, 2008 at 5:09 pm
But what about the transaction log?
suppose i
--start backup of TLog at 6:00 PM
--New transactions occur at 6:01, 6:02, 6:03 PM (as you said that database will continue as normal)
--backup of TLog completed at 6:05 PM
So will the TLog backup contain the transactions between 6:00 & 6:05 or not??
August 21, 2008 at 5:25 pm
This should be a 'question of the day.'
I'm going to posit that they would be included.
August 21, 2008 at 6:09 pm
>> So will the TLog backup contain the transactions between 6:00 & 6:05 or not?
Yes. A full database backup and a transaction log backup will always contain the state of the database and/or transaction log as at the end of the backup. So if your full database backup starts at 6:00 and ends at 6:30, restoring that backup will result in the database as it was at 6:30, not 6:00.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply