SQL Server Transaction Logs

SQL Server Transaction Logs

If I change the recovery model on the primary database from full to simple and then change the primary database back to full again. Would that break the log chain? It seems the log shipping breaks after we do that. Software/Hardware used: SQL Server 2005

Transaction Log - SQL Server 2005

How do i find out what transaction log file was last applied to a database?

Transaction log for read only database...

Hello there, I am currently studying for the 70-432 (MCTS SQL Server 2008 I&M) exam and I am using Microsoft 70-432 Training Kit by Mike Hotek. At some point the book claims "when a database is placed in READ_ONLY mode, SQL SERVER removes any transaction log that is specified for the database....

Trouble backing up our SQL Server transaction logs

Our SQL Server transaction logs have not been backing up, and I discovered it’s because a database was not selected in the maintenance plan. When I select the database and save it, however, it is not saving. It keeps reverting back to the previous option. Does anyone know why?

Scheduling a Shrink Database in SQL Server 2000

Is there a way to schedule a shrink database after the transaction log has been backed up for a database via the maintenance plan?

Facing a problem while working with transactions

I m having my SQL server on Machine A and i m starting one transaction on server from Machine B, now in between suppost Transaction from Machine B creates a new record in one of the table on server using insert into statement, after creating the record the LAN connection of Machine B is...

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...

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...

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?

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...