SQLServerCentral: Content tagged Administration, Transaction Logs

Managing Transaction Logs

A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs. Read more...

By Gail Shaw 2012/01/03 (first published: 2008/10/31) | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 49,668 reads

Stairway to Transaction Log Management in SQL Server, Level 1: Transaction Log Overview

The transaction log is used by SQL Server to maintain data consistency and integrity. If the database is not in Simple-recovery mode, it can also be used in an appropriate backup regime to restore the database to a point in time. Read more...

By Tony Davis 2011/06/17 | Source: SQLServerCentral.com | Category: stairway series

Rating:

|

Discuss |

Briefcase | 12,948 reads

DBA 101: Why is my log file full?

This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central.... Read more...

By Grant Fritchey 2011/01/27 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 2,996 reads

Managing Transaction Logs

A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs. Read more...

By Gail Shaw 2012/01/03 (first published: 2008/10/31) | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 49,668 reads

Transaction Log Growth, do you need it?

One of the most common questions asked about SQL Server has to do with the transaction log and why does it grow. James Rea brings us a good explanation here of what happens and what you should do about it. Read more...

By James Rea 2010/05/28 (first published: 2009/01/05) | Source: SQLServerCentral.com | Category: transaction logs

Rating:

|

Discuss |

Briefcase | 32,186 reads

Move SQL Server transaction log files to a different location via T-SQL and SSMS

I am planning on moving the SQL Server log file of my production database on this drive. I am curious about how it will optimize the performance. What are some of the considerations I should take into account and how can I move the SQL Server database log file to a separate physical location? Read more...

By Additional Articles 2009/07/02 | Source: MSSQLTips.com | Category: administration

Rating: (not yet rated) Rate this |

Briefcase | 2,648 reads

Determining the source of full transaction logs

Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem. Read more...

By Additional Articles 2009/06/15 | Source: SearchSQLServer | Category: transaction logs

Rating:

Rate this |

Briefcase | 3,475 reads

Can you shrink your transaction log files to death?

can undermine server performance. An expert runs various tests to determine how transaction log file size responds to various T-SQL commands. Read more...

By Additional Articles 2009/02/23 | Source: SearchSQLServer | Category: transaction logs

Rating: (not yet rated) Rate this |

Briefcase | 2,967 reads

Transaction Log Growth, do you need it?

One of the most common questions asked about SQL Server has to do with the transaction log and why does it grow. James Rea brings us a good explanation here of what happens and what you should do about it. Read more...

By James Rea 2010/05/28 (first published: 2009/01/05) | Source: SQLServerCentral.com | Category: transaction logs

Rating:

|

Discuss |

Briefcase | 32,186 reads

Managing Transaction Logs

A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs. Read more...

By Gail Shaw 2012/01/03 (first published: 2008/10/31) | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 49,668 reads

Content with tags Administration, Transaction Logs