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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy