Abstract: The present invention provides for multidimensional automated database administration, such that, multiple database scripts can be deployed and executed across multiple database servers and the multiple databases stored therein. In addition, the present invention manages the sequence/order in which the scripts are automatically deployed/executed and provides for automated tracking of execution results including error tracking on a per script basis. Additionally, the invention can be deployed in a distributed network allowing for cross domain connectivity to the database servers for the purpose of executing the database scripts without requiring deployment of server-side script deployment agents.

Abstract: In certain embodiments, a system includes a target server operable to access one or more databases. The target is further operable to run one or more processes supporting access to the one or more databases. The system also includes a management server including one or more processors. The management server is operable to receive a maintenance request. The maintenance request includes a maintenance window. The management server is further operable to generate a server state snapshot by capturing the identities and configurations of the one or more processes running on the target server. The management server is further operable to stop the one or more processes. The management server is further operable to restore, after the expiration of the maintenance window, the one or more processes based on the server state snapshot.