do i need to do anything else? or just cut and paste this to query analyzer without modifying any syntax.

thank you very much for your help.

Iam very new with sql

Question: how and what is the syntax to reindex the log files?

SQLBILL- Sorry about that. I accidentally click post reply twice. thank you very much for your help

(If you only want to shrink the log file then you need to use the DBCC SHRINKFILE command.  YOu use the logical file name not the phyiscal file name. ...

The LDF is bigger than the MDF files. Is this normal? How to shrink the .LDF files? Can you provide me the right command or syntax to...

How about the temdb ldf and ldf? How can you shrink these sizes? Can I just stop and start SQL service or rebooting the server to recover...

I turned the database into simple mode and shrank the files. Thanks

is this the right way of controlling the mdf and ldf files to swith to simple mode.