Suggestion for Tools / Techniques for automating the refresh & subsequent configuration of the Microsoft databases (Aim: minimal effort for the DBAs on an ongoing basis to do this)
Please suggest any tools/methods which we can do the refresh of the DB very easily.
SSIS is useful - if you're looking to manage the process. It gives you very granular control . By referesh, do you mean - restoring a copy from backup or do you mean data load?