setting database recovery mode to simple through a sql script

[wilk]

I have asked to work out a way of setting the recovery mode across all our sites to simple, about 100 in total. I know how to do this using enterprise manager but can't find any documentation of use of how to script it.

Please help

Thanks in advance

wilk

 

[tlbroadbent]

Use the Alter Database command.

ALTER DATABASE SET RECOVERY SIMPLE

It seems unusual to me to set all databases to simple recovery. That means there can be no transaction log backups, no point-in-time recovery, no viewing transaction logs for debugging or recovery from mistakes.

If data loss is acceptable, then go for it. Howerver, if you have transactional data that you do not want to lose in case of disaster, I'd not use Simple Recovery on all databases. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[wilk]

I know why you think this, and to be honest with you so do I, but the people in charge wat it this way.

They believe it to be acceptable because with simple mode you get rollback, but not roll forward, and as the program has not been writen with roll forward in mind it is ok to do this.

I have found out how to do it now anyway, but thanks for your comments.