HI,

I notice that this post is quite old but as it happens I have the same requirement as

May 6, 2018 at 9:14 pm

#1989454

Hi Gail,

Yup. I waited and then it worked! Thanks for your help.

Jonathan

Hi Gail,

Something went a bit funkey with the post and it sumitted itself before I had finished posting, here is what it should have said...

Hi Gail,

Thanks for that, it appears...

Hi Gail,

Thanks for that, it appears that the name is actually log.

I ran the following: DBCC SHRINKFILE(log, 4000)

and got the following:

DbIdFileIdCurrentSizeMinimumSizeUsedPagesEstimatedPages

627301024 ...

Hi Pradeep,

The databse sucessfully backed up last night so all good there, however when I try run:

DBCC SHRINKFILE(Pthprod_log, 2)

I get the following:

Msg 8985, Level 16, State 1, Line 1

Could not...