Hi
Does anyone have any scripts/jobs that automate the load from prod to test
environments. Prod already has dump jobs running. What I am looking for is a
sp or job which will ready the backup history table on prod and get the
latest dump files, xcopy them to test server and load test databases having
first killed users related to the db's being loaded.
Thanks
Hi
http://www.sql-server-performance.com/articles/clustering/log_shipping_70_p1.aspx
"guest5" <guest5@.discussions.microsoft.com> wrote in message
news:D7C7807A-2833-4880-A01E-B285D2A2584F@.microsoft.com...
> Hi
> Does anyone have any scripts/jobs that automate the load from prod to test
> environments. Prod already has dump jobs running. What I am looking for is
> a
> sp or job which will ready the backup history table on prod and get the
> latest dump files, xcopy them to test server and load test databases
> having
> first killed users related to the db's being loaded.
> Thanks
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment