Skip to main content
Server Fault

Return to Question

replaced http://serverfault.com/ with https://serverfault.com/
Source Link
Community Bot
Community Bot
  • 1

What's the position on helping someone with understanding technology, but in response to learning or education rather than a formal 'I have a specific issue ....'

I'm thinking of this question,

Transaction log backupsTransaction log backups

I'm studying for the 70-432 (SQL Server 2008) exam, and I'm a bit confused about how the transaction log works.

From what I understand, (correct me if I'm wrong...) the log is actively stored in memory and copied to a file on the drive as often as possible. At every checkpoint, complete transactions are committed to the data file on the hard drive (that is, they're not actually written to the drive at all until the checkpoint. And the tail always holds the transactions that have not been committed yet.

It's specific, focussed and quite narrow, so it might well get a good answer, but it's not a real problem faced by the person in the true meaning of the phrase.

What's the position on helping someone with understanding technology, but in response to learning or education rather than a formal 'I have a specific issue ....'

I'm thinking of this question,

Transaction log backups

I'm studying for the 70-432 (SQL Server 2008) exam, and I'm a bit confused about how the transaction log works.

From what I understand, (correct me if I'm wrong...) the log is actively stored in memory and copied to a file on the drive as often as possible. At every checkpoint, complete transactions are committed to the data file on the hard drive (that is, they're not actually written to the drive at all until the checkpoint. And the tail always holds the transactions that have not been committed yet.

It's specific, focussed and quite narrow, so it might well get a good answer, but it's not a real problem faced by the person in the true meaning of the phrase.

What's the position on helping someone with understanding technology, but in response to learning or education rather than a formal 'I have a specific issue ....'

I'm thinking of this question,

Transaction log backups

I'm studying for the 70-432 (SQL Server 2008) exam, and I'm a bit confused about how the transaction log works.

From what I understand, (correct me if I'm wrong...) the log is actively stored in memory and copied to a file on the drive as often as possible. At every checkpoint, complete transactions are committed to the data file on the hard drive (that is, they're not actually written to the drive at all until the checkpoint. And the tail always holds the transactions that have not been committed yet.

It's specific, focussed and quite narrow, so it might well get a good answer, but it's not a real problem faced by the person in the true meaning of the phrase.

Tweeted twitter.com/#!/ServerFault/status/208107227763060736
Source Link
EightBitTony
EightBitTony
  • 9.4k
  • 14
  • 10

Revision / Exam questions?

What's the position on helping someone with understanding technology, but in response to learning or education rather than a formal 'I have a specific issue ....'

I'm thinking of this question,

Transaction log backups

I'm studying for the 70-432 (SQL Server 2008) exam, and I'm a bit confused about how the transaction log works.

From what I understand, (correct me if I'm wrong...) the log is actively stored in memory and copied to a file on the drive as often as possible. At every checkpoint, complete transactions are committed to the data file on the hard drive (that is, they're not actually written to the drive at all until the checkpoint. And the tail always holds the transactions that have not been committed yet.

It's specific, focussed and quite narrow, so it might well get a good answer, but it's not a real problem faced by the person in the true meaning of the phrase.