Solved

Data warehouse with transactions log

Posted on 2009-05-14
3
328 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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

685 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