May 21, 2010 at 2:07 am
i have 1.5 gb ldf file i want to trincate it
i m trying dbcc shrinkfile(2, 10, , truncateonly) but size is not reducing why??
May 21, 2010 at 2:23 am
Do you take any log backups?
May 21, 2010 at 2:28 am
no i take only a full backup
May 21, 2010 at 2:31 am
when i changed recovery model from full to simple and run command dbcc shrinkfile (1,1,truncatonly) got reduced donno why is happen, wanna know reason and the actual meaning of my command what did it do
May 21, 2010 at 3:02 am
BOL contains any details you need.
May 21, 2010 at 4:25 am
Take a look through this article - http://www.sqlservercentral.com/articles/64582/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply