SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, Transaction Log Rss

   Items 1 to 18 of 18   
 

Managing Log Files Sizes the Easy Way

Learn an easy, rough, and ready way to manage log files in this piece.  Read more...
By Mark Roworth 2016/12/16 (first published: 2015/03/09) | Source: SQLServerCentral.com | Category: log files
Rating: |  Discuss |   Briefcase | 9,686 reads

Minimally Logged

By Steve Jones 2016/06/21 | Category: transaction log
Rating: (not yet rated) |  Discuss |   Briefcase | 1,271 reads

Getting transaction log space usage statistics for all databases.

Easy way to get the TLOg space Usage details  Read more...
By S M 2015/12/07 | Source: SQLServerCentral.com | Category: space usage
Rating: |  Discuss |   Briefcase | 1,194 reads

Backup log with norecovery

By Steve Jones 2015/09/29 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,524 reads

Reading Logs

By Steve Jones 2015/03/10 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,824 reads

Managing Log Files Sizes the Easy Way

Learn an easy, rough, and ready way to manage log files in this piece.  Read more...
By Mark Roworth 2016/12/16 (first published: 2015/03/09) | Source: SQLServerCentral.com | Category: log files
Rating: |  Discuss |   Briefcase | 9,686 reads

Minimum Number of VLFs

By Mike Hays 2013/11/27 | Category: transaction log
Rating: (not yet rated) |  Discuss |   Briefcase | 1,753 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 2013/10/30 (first published: 2011/06/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 21,960 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 | 58,295 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 2013/10/30 (first published: 2011/06/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 21,960 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 | 3,417 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 | 58,295 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 log
Rating: |  Discuss |   Briefcase | 32,309 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 | 3,517 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 log
Rating:  Rate this |   Briefcase | 3,929 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 log
Rating: (not yet rated)  Rate this |   Briefcase | 3,367 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 log
Rating: |  Discuss |   Briefcase | 32,309 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 | 58,295 reads
   Items 1 to 18 of 18   
 
Tags
backup and restore (1)    
blogs (1)    
drive space (1)    
log files (1)    
norecovery (1)    
shrink database (1)    
space usage (1)    
stairway series (1)