I did the following
use ABC
go
checkpoint --ok
go
backup log with truncate --error
go
dbcc shrink empty --error
go
when I changed to
backup log ABC with truncate_only --OK
dbcc shrinkdatabase(ABC, 10) --error in use
dbcc shrinkfile(ABC_log, 10) --error in use
-D




Reply With Quote