Hi there,

I am new in the sql enviroment, so pleae be gentle and offer your advice!

I need some help concerning the maint plan in EM. I need to run complete backups on all my databases(about 2000 DB's) When i use maint plans the "Transaction Log Backup Job" fails because the recovery models of the DB's differ.

This part i understand, but i need a script that i can run that will automatically detect recovery model and do backups accordingly! Because about half of my DB's are DEVELOPER DB's. So i cant go and schedule different jobs for every database, and go back to check them everyday! That will be a monitor nightmare.

Please help me, any help will be appreciated.

Piet