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, that would be amazing to make it a scheduled job- I'd be very interested in that.
And I'm very sorry to hear about your admin. Let us know if there's any way we can help out.
Thank you, Kathleen. And thank you everyone that has expressed sympathies. Our beloved Maria was one of those wizards that quietly handled so much in our little 2 person IT shop here and we're only just now figuring out the scope of things that need to be taken over by myself and a new temporary hire. Our responsibilities were divided in strange ways; I am the DBA and handle Tessitura stuff generally, but because she was the Network Administrator, she would handle server-related things, so she would be the one to do the LIVE-to-TEST copies and Tessitura version upgrades, etc.
Anyway, to Gawain and Nick, anything you could offer would be most helpful since I don't relish the idea of waiting for our Customer Care/Telemarketing teams to go home around 8:00 p.m. before I can start the LIVE-to-TEST and going home afterward at 10:30 p.m. or so during rollover time.
Thanks again, Tessiturians.