This is why its critical to document and define business-critical systems and data paths. Sounds like you don't have this, if you did, it would be a simple matter...

Ok for SSRS looks like I could take the approach of moving them to a new instance, by copying off the reportserver* db's and then restoring them after reinstall. ...

I wouldn't worry about that, I'd take the 'remove the band aid' approach myself. Stand up Prod, and say the cut over is of X date, and have everyone on...

Did you perchance change your recovery model from Simple to Full without ensuring that log backups were being taken?

I have a package that exports all my SSIS packages as dtsx files into a particular file share controlled by a variable. I would think you could use the same...

Have you tried using an export column task in SSIS to do this? I use this approach to export all of my stored SSIS packages in MSDB, should work...

I prefer Data Janitor myself. More appropriate most of the time.

Did you try running a dbcc checkdb on the database its supposed to be in? Are you getting any errors from your storage/san?

Better idea is to run the script on a staging environment that is a clone of production.

nonghead-webspam (3/27/2014)

---

Point taken....

LSAdvantage (3/21/2014)

---

I have chuckled about this several times already today! This is great!

As if I...

I accidentally scrambled production data in an effort to scramble DEV data once.

Lucky for me the data was recoverable from a cloned table on another database.

Is it using an application role?

Maybe that's the disaster, the dba is hit by a bus.

Replace function might do what you are wanting.