How do I create a process that will:
- backup Database A restore it as Database X (needs to be definable)
- then run a stored procedure against Database X.
- shrink and truncate its log file.
Anybody got ideas? Could it be a stored proc on the Master db?
The whole process takes hours and is taking me away from valuable time.