Hi guys, thanks for the reply and advice.

Regard

Yes, thanks for the advice.

Since Full + Tlogs more beneficial then simple, will stick on full backup, instead. (as there is no negative impact on...

Hi guys, thank a lot for the reply and sharing.

I guess i found the actual issue, after the DB migrated, the server name was renamed and ...

Yup, After dealing a few modellog transaction, the modellog shirnk itself.

Thank you people.

Thank for the great help, yes, the object is unchecked.

Oh ya. The file did not shrunk after i ran the shrink database. It's a huge 1.7G.

Thank, wonder why too? Will this affect the entire DB.??

Thank you. Yes, it's funny. Using sa account. Anyway to get its out?

Actually i try to attach the DB, but EM mentioned that the file is in use. Sigh.

On...

Hm,

Nope in Enterprise Manager but with Query Analyser, yes. I manage to see the Database.

My purpose is to shirnk the these files.? Any Tips.?

Thank you.