michael vessey (5/21/2012)
looking at that you definatly have a couple of DB that are in simple (WRHL for one) and that will cause that statement to potentially fail..i think you should really look at your strategy before implementing any changes though - your databases that are in full recovery are having the log truncated- which is pretty pointless.... you would be better just getting rid of those commands and switching to Simple recovery mode.. Its a lot safer
Micheal Thanks for the prompt but im still lost, if i want to change from full to simple how do i go about it?
-----The icon looks like a normal DB and its not restoring its in full view and is usable.........