Solved

Data warehouse with transactions log

Posted on 2009-05-14
3
301 Views
Last Modified: 2012-05-07
Hi

Can anyone tell me, would a data warehouse have transaction log, if so what would it contain?

Thanks
0
Comment
Question by:ac_davis2002
3 Comments
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 500 total points
ID: 24389172
EVERY SQL Server database has a transaction log.  A transaction log contains information about all transactions that have occurred within the database since the last time the transaction log was cleared/backed up.  Every update/insert/delete statement will utilize the transaction log.

If the database is set to SIMPLE recovery mode, and not FULL, then the log is CLEARED at checkpoint.
0
 
LVL 7

Expert Comment

by:Hemantgiri S. Goswami
ID: 24392092
Hi,
Brandon's answer explains about T-Log, is this what you are looking for? Please elaborate if not.
Regards
Hemantgiri S. Goswami
0
 

Author Closing Comment

by:ac_davis2002
ID: 31581612
Excellent
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now