Click here to Skip to main content
15,919,613 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Favicon problem? Pin
sashidhar12-Oct-09 5:54
sashidhar12-Oct-09 5:54 
Questiondynamic control in separate class Pin
dkosasih12-Oct-09 2:22
dkosasih12-Oct-09 2:22 
QuestionDBA Pin
AndyInUK12-Oct-09 2:10
AndyInUK12-Oct-09 2:10 
AnswerRe: DBA Pin
sashidhar12-Oct-09 2:32
sashidhar12-Oct-09 2:32 
AnswerRe: DBA Pin
keyur satyadev12-Oct-09 2:59
keyur satyadev12-Oct-09 2:59 
GeneralRe: DBA Pin
AndyInUK12-Oct-09 3:43
AndyInUK12-Oct-09 3:43 
GeneralRe: DBA Pin
Abhijit Jana12-Oct-09 4:32
professionalAbhijit Jana12-Oct-09 4:32 
AnswerRe: DBA Pin
David Mujica12-Oct-09 3:18
David Mujica12-Oct-09 3:18 
Are you still havign trouble with your transaction log ?

I understand you want a permanent fix to your transaction log file growing, but there is no "fix" to your problem. This is normal operation of a database, each time a record is inserted/updated/deleted, there is a before and after image of the record written to the transaction log so that you can either rollback the transaction or apply re-do logs after a database crash. You can't prevent transaction logs from growing, you just need to know how to manage them.

For example, the most basic management of SQL db could be implemented as follows:
1) Set the recovery model to "simple"
2) Each night, perform a full backup of the database.
3) Truncate the transaction log file

Also, you may want to review the following TechNet article ...

How to stop the transaction log of a SQL Server database from growing unexpectedly

http://support.microsoft.com/kb/873235[^]
GeneralRe: DBA Pin
AndyInUK12-Oct-09 3:30
AndyInUK12-Oct-09 3:30 
AnswerRe: DBA Pin
Abhijit Jana12-Oct-09 3:20
professionalAbhijit Jana12-Oct-09 3:20 
AnswerRe: DBA Pin
chandni patel12-Oct-09 4:13
chandni patel12-Oct-09 4:13 
GeneralRe: DBA Pin
AndyInUK12-Oct-09 4:14
AndyInUK12-Oct-09 4:14 
GeneralRe: DBA Pin
Abhijit Jana12-Oct-09 4:31
professionalAbhijit Jana12-Oct-09 4:31 
GeneralIntellisense Simulator! Pin
tunsten12-Oct-09 1:52
tunsten12-Oct-09 1:52 
GeneralRe: Intellisense Simulator! Pin
Abhijit Jana12-Oct-09 2:04
professionalAbhijit Jana12-Oct-09 2:04 
QuestionHow to remove Request.QueryString from an URL paht in IE Pin
thomasa12-Oct-09 1:32
thomasa12-Oct-09 1:32 
AnswerRe: How to remove Request.QueryString from an URL paht in IE Pin
April Fans13-Oct-09 0:47
April Fans13-Oct-09 0:47 
QuestionHow to redirect on first and last page of gridview using object datasource? Pin
Ravi Mori12-Oct-09 1:26
Ravi Mori12-Oct-09 1:26 
AnswerRe: How to redirect on first and last page of gridview using object datasource? Pin
Abhijit Jana12-Oct-09 1:59
professionalAbhijit Jana12-Oct-09 1:59 
GeneralRe: How to redirect on first and last page of gridview using object datasource? Pin
Ravi Mori12-Oct-09 2:54
Ravi Mori12-Oct-09 2:54 
GeneralRe: How to redirect on first and last page of gridview using object datasource? Pin
Abhijit Jana12-Oct-09 3:06
professionalAbhijit Jana12-Oct-09 3:06 
Questioniis7 Urlrewriting module Pin
Ramkumar_S12-Oct-09 1:00
Ramkumar_S12-Oct-09 1:00 
AnswerRe: iis7 Urlrewriting module Pin
Not Active12-Oct-09 1:26
mentorNot Active12-Oct-09 1:26 
QuestionHTTp post Pin
ellllllllie12-Oct-09 0:47
ellllllllie12-Oct-09 0:47 
AnswerRe: HTTp post Pin
Abhijit Jana12-Oct-09 1:51
professionalAbhijit Jana12-Oct-09 1:51 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.