February 22, 2006 at 1:39 pm
do bak up transaction logs append to or create a separate log?
for that matter, how do you resture from a transaction log that is say from 2 months bak. if you have a separate bak up for example Dec Jan, Feb
is this the correct idea and if so, in Enterprise manger exactly how and wheredo you do it?!!!
February 22, 2006 at 1:46 pm
From BOl..
database and transaction log backups works only if you have an unbroken sequence of transaction log backups after the last database or differential database backup. If a log backup is missing or damaged, you must create a database or differential database backup and start backing up the transaction logs again. Retain the previous transaction logs backups if you want to restore the database to a point in time within those backups.
The only time database or differential database backups must be synchronized with transaction log backups is when starting a sequence of transaction log backups. Every sequence of transaction log backups must be started by a database or differential database backup.
Usually, the only time that a new sequence of backups is started is when the database is backed up for the first time or a change in recovery model from Simple to Full or Bulk-Logged has occurred
-Krishnan
February 23, 2006 at 7:18 am
Each transaction log backup contains only the log information that was created following the previous transaction log backup. Transaction log backups are only valid when the database is in Full or Bulk Logged recovery mode.
Therefore, if you create a transaction log backup every hour, backup 1 will contain data from 00:00 to 00:59, backup 2 will contain data from 01:00 to 01:59, etc.
Note that a full database backup does not clear a transaction log. If your recovery mode is Full or Bulk Logged you must do transaction log backups (or truncate the log manually) or your transaction log file will grow indefinitely.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply