One more question! I would like a maintenance plan to delete .bak & Log files older than say 1 week. Is this achieved via 'Clean Up History' 'Maintenance Plan History'?
Update:
I created a new query with the the script you provided to determine fragmentation level? I take it that was what I was supposed to do? I ran it and it ran OK, returned 'No Rows Affected'.
Thanks,
Phil.
PS: You were correct regards 'Recovery Model'. The developers must have been playing.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper