Re: Recovery Model Question.

Yes,exactly.
I want to change massive all the 200 databases recovery
model option from full to simple but i dont want to achieve this manually
because of the huge overhead.
For that reason i asked ,if theres a more quicker and better way to achive
this.

Thnx a lot.
Cipher.


"Immy" <therealasianbabe@xxxxxxxxxxx> wrote in message
news:%23DV67OlZHHA.348@xxxxxxxxxxxxxxxxxxxxxxx
Are you asking for a way to change this value against 200 different
databases?

"Cipher" <cipher@xxxxxxx> wrote in message
news:eIh22lkZHHA.4772@xxxxxxxxxxxxxxxxxxxxxxx
Hello to everyone,

I want to ask if there is a way ,maybe through a strored procedure or sql
script
to change massive in 200 databases for example the recovery model from
full to simple ??
If anybody has an idea or knows i will appreciate it.

Thanx a lot.
Cipher.





.

Loading