Good question, thanks Steve.

Had to think twice there then realised the question said Rows, nice one!

I stand corrected I was thinking log as I recently had the issue.  Apols to OP for confusion.

Just a thought you need to check the number of VLF's and which is the active one, this will indicate whether a shrink is actually possible.

Good basic question, thanks Steve.

Learned something new, thanks Steve.

Good question thanks Steve

Nice simple one, thanks Steve.

Nice question, thanks Steve.

Good question, thanks Steve

Good question and learned something new, thanks Steve

Good question, thanks Steve.

Thanks for the reply, by fresh install I mean brand new on new server, the database is newly created. Compared with an existing report server installation it appears to have...

Learnt something new thanks Steve.

Did this year's ago, it was way back and what was required was to set up cross domain trusts such that one domain was trusted and the other trusting.