Logs

Just a note, one day I must spend a lot more time reviewing the details around transaction logging and restore for production databases. The fact that i generally work on marketing systems where the server tends to be more for experimentation means I’m usually really lax on organising the setup. With that in mind, there are always a couple of business critical elements that need to be resolved, all of which become a priority when things start to go a bit sideways.

http://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput/

which i stole from this thread http://www.sqlservercentral.com/Forums/Topic650142-357-1.aspx

Seems to be a good place to start. In future, setting to Simple when relying on a restore without the need to roll back transactions should also be a good idea….

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s