September 15, 2005 at 2:24 am
Hi,
I want to that on every checkpoint the log should be truncated.
from
Killer
September 15, 2005 at 3:24 am
Change the database option to truncate log file on checkpoint
September 15, 2005 at 3:30 am
Hi Sufian,
Try out this
USE master
go
EXEC sp_dboption 'model','trunc. log on chkpt.',true
go
USE model
go
CHECKPOINT
go
hope this help u
from
Killer
September 16, 2005 at 10:33 am
This sp will be 'removed' sometime in the future ...
Use "ALTER DATABASE your_database_name SET RECOVERY SIMPLE" instead.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 16, 2005 at 10:29 pm
Hi Rudy,
What does this means
This sp will be 'removed' sometime in the future ...'
from
Killer
September 19, 2005 at 1:19 am
Rudy means.,
Mircosoft may not support this SP. Better to use ALTER Database.,
September 19, 2005 at 1:26 am
Yes ,
I know this will not be supported by microsoft.But till it is there we should use it .
from
Killer
September 19, 2005 at 2:18 am
Correct., yes it is supported even with SQL 2005. But MS recommends to use ALTER DAtabase Syntax.
September 19, 2005 at 8:26 am
Raj, I think the idea is that it's best to use the "supported" methods because if you have any "unsupported" coding in stored procedures or jobs, when that code is no longer supported, your applications will break, and you'll spend time & energy tracking down the problem. So, it's best to use the code that you know doesn't run the risk of breaking in the future.
September 20, 2005 at 8:15 pm
Thanx
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply