SQL Server transaction logs

SQL Server 2000/2005 Transaction Logs

Quick Ques.Are transaction logs cummulative?If I have a database set to Full recovery mode; database being backed once a day and transaction logs being backed up hourly, if the database needs to be restored, can I just restore the last transaction log file? Will the last transaction log file...

View Answer   |  Sep 17 2008   3:20 PM GMT   |  asked by JCDBA
SQL Server transaction logs, SQL Server 2005, SQL Server 2000

SQL 2005 Transaction Logs

I am by no means very good at SQL. I know the basics. I am a network engineer but was recently asked to do a few tasks in a SQL 2005 environment. I currently have a database that is residing off-site and I was asked to import the database and transaction logs so that this server can be used for...

View Answer   |  Jun 9 2008   4:17 AM GMT   |  asked by Danyluk
SQL Server administration, SQL Server transaction logs, SQL Server 2005

Looking for a stored procedure to monitor size of Transaction Log file

Is there any way I can create a stored procedure which will check for the Transaction Log file size - where we have a specified limit to grow - and if the Log file reached 80 percent of total size, email alerts can be sent to DBAs?

View Answer   |  Apr 18 2008   1:11 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server transaction logs, SQL Server stored procedures, SQL Server availability

How to control SQL Server transaction log growing to a maximum size

Transaction log in SQL Server getting completely growed to maximum size frequently even when it is being backed-up and shrinked.. Please provide early and feasible solution.. What is the possible cause for the growth of transaction log to that extent.. and how to avoid it...

View Answer   |  Jan 24 2008   1:54 PM GMT   |  asked by 19091981
SQL Server transaction logs, SQL Server