December 8, 2008 at 9:56 pm
i have taken a log backup with truncate only, the chain of log sequence break..
but i nedd to take log backup with truncate..bac of log file size is full..
Is there any way to truncate log file and sequence is not break?
December 8, 2008 at 10:18 pm
Hello Paresh,
Nice try to understand the SQL Backup.
Just think one step ahead of and try to understand the internal mechanism...
When full backup is running it is taking the snapshot of the Database i.e. captureing the all Datapages considering all the changes during the Full backup. Hence when you do have Full backup; you do have all the commited transaction till the Full backup completed. i.e. Here if you Fullbackup completed around 5:02am it contain all the commited transactions till 5:02am.
Keep moving.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 8, 2008 at 10:21 pm
Paresh Prajapati (12/8/2008)
i have taken a log backup with truncate only, the chain of log sequence break..but i nedd to take log backup with truncate..bac of log file size is full..
Is there any way to truncate log file and sequence is not break?
No. The BACKUP LOG will invalidate completed transactions allowing the space to be reused. If you transaction log file has filled your disk, you can shrink the transaction log file using SSMS to shrink the log file.
If the log file expanded to the point that it filled your drive, you need to see about moving it to a larger disk drive or increase the frequency of your transaction log backups.
December 8, 2008 at 10:33 pm
Means Full backup also contain commited transactions, which are also commited in transaction logs which are backuped during Full backup.!!!
December 8, 2008 at 10:57 pm
But the t-log backups will only have the transactions from entered since the last t-log backup.
Is your disk drive filling up during the full backup?
December 9, 2008 at 1:17 am
Lynn Pettis (12/8/2008)
But the t-log backups will only have the transactions from entered since the last t-log backup.Is your disk drive filling up during the full backup?
disk drive filling up during the full backup in regarding what?
MDF or BackupFile?
Viewing 6 posts - 31 through 35 (of 35 total)
You must be logged in to reply to this topic. Login to reply