My Transaction Log keeps filling up.
Truncate on checkpoint is set on the database. The checkpoint frequency is every 5 minutes.
Some transactions are remaining in the log.
What things cau...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10216064.html
Hi
Someone on our network maked a change to one of our database on friday moring, i would like to know if there is a way to see who make this change with out buying any software to do this.
th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21661596.html
I know that Backup Exec will remove transaction logs, however, our transaction logs are going to a folder that was created (before I came here I might add). Anyway, I wanted to do a test of the RS...
http://www.experts-exchange.com/Software/Server_Software/Email_Servers/Exchange/Q_21838511...
Zones:
ExchangeDate Answered: 05/05/2006 Grade: A Views: 0
I have a database of all the event logs in the environment. Its up @ 150 GB. I have set up scripts to run daily that delete events older than a certain date. The problem is that the transaction ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21918127.html
the no_log option does exactly what truncate_only option does except that the operation of dumping the transaction itself is not logged. what is the use of logging that operation, can it be rolled ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10069096.html
Zones:
MS SQL ServerDate Answered: 08/03/1998 Grade: A Views: 122
I have a database which had dyn. growt of log, the log is now 500 MB, I want to clear that, but it won't when I use truncate log it is ready immediatly, but nothing is done, I have found the comman...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10416598.html
Hey!
I've a stored procedure that is doing a lot of inserts and deletes etc and every so often it fails midway through saying transaction log is full.
The data is non-critical and I was thus won...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10496719.html
I need to move the transaction log for an SQL Server 6.5 database. What is the easiest way to perform this action?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11372398.html
How i can read transaction log file (*.ldf) or rollback 1000 transactions? Is it's possible?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20133012.html
I have a SQL Server 7 transaction log that is greatly oversized, but I can't seem to shrink it down. I've truncated the log, and tried shrinking it via EM and DBCC commands without success.
What c...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20161590.html
