raadee (8/22/2013)
The 10 is the target size, so you would end up with a transaction log that is 10MB.
So u mean when i specify
dbcc shrinfile(2,10)
it tryies to reduce log file to size of 10MB (and not 90MB) provided there is data of size less then 10 MB in log file.
Am i right.please reply
Reagrds
Anoop