Welcome to

SqlServer-QA.net

Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
Transaction Log Guidelines

I always see many posts in the forums asking about transaction log backups and their importance. For the point in time recovery they are must in order to provide the data upto date or atleast that are committed.

Yet I have seen many articles out there explaining the importance and tasks for every DBA needs to take care:

TlogGuideline - excellent article covering all the aspects of transaction log and its features.

Backup-Recovery importance including the coverage for recovery model

KBATransLog - explanation on the transaction log

BackupRestore explanation 

The above links are very useful for a newbie DBA and database support people.

Posted: Tuesday, June 19, 2007 2:09 AM by SQL Master

Comments

SSQA - SqlServer-QA.net said:

I always see many posts in the forums asking about transaction log backups and their importance. For

# June 19, 2007 3:54 AM
Anonymous comments are disabled