Remember to use NVARCHAR(x) in your stored proc and not VARCHAR. We had a situation where the stored proc was created to accept the string from ssrs as a varchar....

For each database in our org.

1 Production (failover cluster)

1 Production Mirror

1 Reporting Server (copy from midnight)

1 International copy to EU

1 International copy Mirror

1 Full backup (onsite)

1 Full backup (offsite)

1 QA...