Noob SQL question on a command

I have a SBS 2008 server who's log file is huge.  The actual database is 5 MB, but the log file is 11 gigs.  I found this
http://msmvps.com/blogs/kwsupport/archive/2008/12/10/sbs-2008-and-sharepoint-log-file.aspx

And it is what I want to do, but when I run the first command,
sqlcmd –E –S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
it tells me
sqlcmd: '-E': unknown option.

Anyone have a tip on this?
LVL 9
tsaicoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tsaicoAuthor Commented:
Ok, I found this, and it seemed to work out normally, but after I select Shrink Files, release unused space (which the system shows as 99% free now) it just flashes back and goes back to the same GUI i started with.
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_26935251.html

And the file path still shows the 11 GB file.  Does it take some time to shrink or give any indicator it is still working (or erroring out for that matter)?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tsaicoAuthor Commented:
boy, perhaps I am just posting these in the wrong place or not giving Google searches enough, my third I have answered on my own without so much as a comment or suggestions..

In case someone goes over this same problem, here is how I fixed it.  I did this
http://www.howtodo.co.il/?p=428

and it worked great.  It also seems to be a better long term so the log isn't unlimited and will only have 1 gig worth of text data to review, which I am sure is enough in case there is a larger underlying issue which is causing this log to grow like this.
0
tsaicoAuthor Commented:
No one answered or suggested anything and I googled it myself.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.