New answers tagged maintenance
I tilted on your "data loss could have legal ramifications here" comment. Then, you definitely want to get a powerful 3rd party tool (like DPM) that can handle backups (and recover from catastrophics events in a flash and minimal fussing around) alot faster and alot better than any script you can pull off the Internet. Having backups is one thing. Knowing ...
The tool we use to remove duplicate records in our database (Access) is WinPure Clean & Match, I think also they do an API for fuzzy matching.
Create stored procedures that do these tasks for them - these can be set to execute as owner and the user account can just be granted execute rights on the stored procedures. It means they'll have to learn the interface to your stored procedures (so document them well or give them view definition rights to them also).
Top 50 recent answers are included