Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Difference between Transaction Log & Database Log File Expand / Collapse
Author
Message
Posted Tuesday, July 15, 2008 11:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 2:44 PM
Points: 238, Visits: 444
Hi,
1-Whats the difference between Transaction Log & Database Log File?
2-When we take back of a database, does it also includes the Database Log File in the backup?



Thanks,
Usman
Post #534614
Posted Tuesday, July 15, 2008 12:43 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:18 PM
Points: 4,065, Visits: 5,284
1. A log file is the physical location that holds the transaction log data.

2. A full backup will backup enough of the transaction log to allow recovery of the database to the time the backup was taken.


Greg
Post #534676
Posted Tuesday, July 15, 2008 12:48 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 2:44 PM
Points: 238, Visits: 444
So how will the data BETWEEN a full backup and a transactional backup will be restored, assuming that checkpoints occurs AFTER the full backup and data was flushed and REMOVED from the transactional log into the database(this data will not be available in the backup or transaction log).
Post #534682
Posted Tuesday, July 15, 2008 12:51 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:21 PM
Points: 42,495, Visits: 35,566
Transaction log entries are only purged on checkpoint if you are running in simple recovery mode. If you are in simple recovery mode, you cannot run log backups at all.

In full recovery mode transaction log entries are only removed from the log after a log backup.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #534686
Posted Tuesday, July 15, 2008 12:54 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 2:44 PM
Points: 238, Visits: 444
Gila u r just too gud.......
Greg thanks alot that helpfull too.........



Thanks,
Usman
Post #534690
Posted Friday, April 17, 2009 9:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, March 9, 2011 6:11 AM
Points: 12, Visits: 105
hi this is vijayanand and im from bangalore,

logfile: It hold the eventual information or history information of a data.
Tlog: It holds no data ,it holds only the structure ,

This is very important and most of the people miss their view in simple thinks
Thank you


sanna
Post #699511
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse