Ermergency!

I have a database that was in Simple mode so the log was getting
truncated at checkpoints. I explained to the users that this meant they
would lose all data if it goes down at all and setup a backup of the log
and set it too full recovey mode.

Now the log is expanding so fast I cannot enter EM to change the
properties... back to simple till I work out why it is expanding at
about 1gb every 5 mins... what is the syntax to set it back to simple?

HELP!


----------------------------------------------------------------------
Scope is a registered charity number 208231.
Visit our website at http://www.scope.org.uk

This message, and any file(s) transmitted with it are confidential
and are intended only for the person(s) to whom they have been
addressed by the sender. This message may contain confidential and/or
privileged material. If you are not the intended recipient of this
message, or if you believe it was transmitted to you in error, you are
required to delete the message and any copies of it, and to notify the
sender immediately. Any unauthorised disclosure, copying, distribution,
or printing of this message or accompanying files, or unauthorised use
of any information contained therein, by anyone other than the
intended recipient(s) is prohibited and may be unlawful.

Any views expressed in this message or in any file(s) transmitted with
it are those of the author, and may not necessarily represent the
views of Scope.

MS Sql Server LazyDBA home page