Thanks for the replies Brandie & lindss01. For all our environments, except the one mentioned, we use both of your procedures combined. Development, testing, UAT and finally production. Nothing...

Then again, this is the same DBA who has not removed AdventureWorks from the production environment and is backing it up daily.

Also, there are no system database backups and...

I just couldn't believe it when I found out, and have since informed our CIO who has immediately put a stop to the practice.

Still can't quite get my head...