How can i save my t-log? b? simple recovery mode? what if i want a point in time recovery? Even backing up the database doesnt save the t-log?

So you mean by changing the database option to simple recovery mode I can save my transaction log? I thought simple recovery mode will nat save T-Logs?

Can someone explain this I think I know the reason why my transaction log is shrinking... before i run the BACKUP LOG <dbname> WITH TRUNCATE_ONLY my log file have values...

Thanks for the correction Phil, yes actually the script originated in the script library but when i ran it errors occured (in sql version 7.0) so i made a modification...

Try this:

/*

Script made by Lester A. Policarpio September 03, 2007

Any questions or clarifications feel free to email me at:

lpolicarpio2005@yahoo.com

NOTE: This script can be run instantly or by using job...

BTW here is the script i used (stored procedure) than can be run as a job schedule :

CREATE PROCEDURE usp_DeleteOldBackup

AS

DECLARE @path varchar(1024)

DECLARE @extension varchar(3)

DECLARE @pathension varchar(1000)

DECLARE @DeleteBeforeDate datetime

DECLARE @FName...

Thanks ALZDBA ur a great help two thumbs up

How frequent does this CHECKPOINT occur?

Ahhh that i guess i forgot or i mean  do not know  sorry for being a noob im just a fresh graduate and only...

Based on your monitoring how much GB does the transaction log consumed in a day?if the transaction log did not consume the total amount of transaction log in a day...

MAtt is right you can calculate the amount of space that the transaction log can consume for 1-2 days then stay at those sizes and keep truncating the transaction log...

@TOPIC

Guys any insights??? when i removed the truncate command (BACKUP LOG <db> WITH TRUNCATE_ONLY) the transaction log became stable then when i run the script again (thurs) it shows stability...

Ahhh ok thanks Phil & ALZDBA

Ohh im too noob hehehe thanks now i know why... another thing is there any effect on the database if I unchecked the autoclose checkbox??

When i run sqlperf in master database this is the output:

master 2.4921875 44.416145 0

tempdb 0.7421875 50.789474 0

model 0.9921875 41.190945 0

msdb 2.2421875 33.253483 0

pubs 0.7421875 51.710526 0

Northwind 0.9921875 45.767715 0

SSADB 3738.8047 1.0285394 0

Student_Info 0.7421875 49.342106 0

Data 4.875 8.2131414 0

Data_Replication 0.9921875 39.222443 0

Loans 0.9921875 39.616142 0

McSystem 3441.3047 0.80714643 0

*12 out of 15 database only appeared

When i run your script the output below appeared:

Data torn page detection,

Data_Replication torn page detection,

DBA autoclose,trunc. log...