How to configure the SQL server to delete or create a new transaction log when the maximum file size has reached
http://www.experts-exchange.com/Database/Miscellaneous/Q_20572753.html
Zones:
DatabasesDate Answered: 02/19/2004 Rating: 7.6 Views: 0
If ldf files contain only logs, are they really necessary? Can the log file be somehow deleted, or can it start logging from scratch, so that only new transactions are logged?
Thanks
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20941896.html
Zones:
MS SQL ServerDate Answered: 04/04/2004 Rating: 9.2 Views: 0
Hello,
I am having a problem with SQL Server, yesterday I took a SQL Server offline. When I brought the server back online, a number of databases had become suspect. I tried rebooting the server...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21059932.html
Zones:
MS SQL ServerDate Answered: 08/10/2004 Rating: 8.0 Views: 0
Hi...
I'm struggling with structuring some code to perform the following. Can someone help me with the logic/code?
I am running a delete query to clear a couple database rows, these records r...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_21165737.html
Zones:
C#Date Answered: 10/13/2004 Rating: 9.6 Views: 0
Our backup has failed and the transaction logs are running out of disk space. I will get the new tape tomorrow but the transaction logs partition will be full in three hours or so.
I have files d...
http://www.experts-exchange.com/Software/Server_Software/Email_Servers/Exchange/Q_21482734...
Zones:
ExchangeDate Answered: 07/07/2005 Rating: 8.2 Views: 0
I'm getting errors every now and then saying "THe log file for database "tempdb" is full. Backup the transaction log for the database
to free up some log space".
There's 25GB free on the drive,...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21851600.html
Zones:
MS SQL ServerDate Answered: 05/18/2006 Rating: 8.6 Views: 0
Hi Guys
I have set up a Maintenance Plan to backup the Transaction File daily.
I thought this would truncate the Transaction file.
But it seems to get bigger and bigger.
Can someone help ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_22859001.html
Zones:
DatabasesDate Answered: 10/01/2007 Rating: 9.8 Views: 0
How can I shrink or reduce transaction.log file
Thanks in advance
aglush
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11560279.html
Zones:
MS SQL ServerDate Answered: 09/24/2003 Rating: 8.2 Views: 0
My Transaction Log File have grown too large now. How do I shrink it.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20177564.html
Zones:
MS SQL ServerDate Answered: 09/03/2001 Rating: 8.2 Views: 0
I've got a program which uses transaction to wrap up all the changes being made to a series of tables. However when the program crash because of enviroment problems (i.e. an idiot turns off the co...
http://www.experts-exchange.com/Microsoft/Applications/FoxPro/Q_20382230.html
Zones:
FoxProDate Answered: 11/19/2002 Rating: 7.4 Views: 0
