I seem to recall at a conference one time someone presented a script that essentially made the dreaded LIVE to TEST copy an SQL Server Agent Job that you could schedule whenever you liked (like in the middle of the night when no one else would be using the system) and not be stuck up at the office for two hours. Perhaps it was one of those Mini-Magic solutions?
Does anyone recall that, and if so, can they direct me to such precious materials? Our network administrator used to perform LIVE-to-TEST copies and she recently passed away suddenly. With rollovers coming shortly, I'd love to be able to get this solution up and running in time.
Thank you in advance, as always, Tessiturians.
Wow, sorry to hear about your admin. Mini magics should be available for download on the conference site.