Top "Transaction-log" questions

transaction log is a log file of all actions performed on a database.

How do you clear the SQL Server transaction log?

I'm not a SQL expert, and I'm reminded of the fact every time I need to do something beyond the …

sql-server transaction-log
DBCC SHRINKFILE on log file not reducing size even after BACKUP LOG TO DISK

I've got a database, [My DB], that has the following info: SQL Server 2008 MDF size: 30 GB LDF size: 67 GB I …

sql-server backup transaction-log dbcc
How to view transaction logs in SQL Server 2008

I need to view the transaction logs of a database on SQL Server 2008 in order to find a delete transaction …

sql-server transaction-log
How Can I Manage SQL Server Log Size

I'm trying to manage the size of a SQL Server 2008 log file. I have a reporting database that is loaded …

sql-server transaction-log
Restore SQL Server DB without transaction log

Given a SQL Server 2008 .bak file, is there a way to restore the data file only from the .bak file, …

sql-server restore transaction-log
Where can I find the MySQL transaction log?

Does MySQL keep a transaction log and if so where could I find it? A number of rows have mysteriously …

mysql transaction-log
How to get the logical name of the transaction log in SQL Server 2005

I am trying to write a T-SQL routine that shrink the transaction log file using DBCC SHRINKFILE based on the …

sql-server transaction-log
SQL Server: how to query when the last transaction log backup has been taken?

I would like to query for all databases (in SQL Server 2008 instance) date when the last transaction log backup has …

sql sql-server sql-server-2008 backup transaction-log
SQL Server: How do I increase the size of the transaction log?

How do I increase the size of the transaction log? Is is also possible to temporarily increase the transaction log? …

sql-server tsql transaction-log
How to perform SQL Roll back from transaction logs

I have transaction log file that goes back 6 months. I need to roll back everything that happened after 5/20/2013 from a …

sql-server-2008-r2 rollback transaction-log