Centralized Administration in a Distributed Environment (ASP and SQL Server)
September 7, 1999?bill's vast expanse (my personal web site since 1995) includes a collection of SQL Server admin scripts, tools, and utilities I collectively refer to as the admin subsystem. The tool set is intended for the DBA working in a distributed SQL Server 6.5 environment that finds the Maintenance Wizard too limiting. Features include automated DUMP/LOAD replication, error reporting by email and network broadcast, and log dump replication with automated failure recovery.
This article will describe a three step implementation of the utility. The first step will be to set up an Intranet web site that will allow you to check the status of the active scheduled tasks on a SQL Server. In this step, you must resolve all issues around web site access and security. The second step will be to establish a database that will act as the focal point of all administrative tasks in the environment. The aim will be to establish a single point of maintenance administration. The third step will be to enable the browser front end to drive the administrative database. This will provide you with an alternate access to your SQL Server administration system for those times when you do not have access to an Enterprise Manager. At this point you will be prepared to modify and enhance functionality of the admin subsystem to the precise requirements of your organization.
So, if you're ready and interested start building your admin subsystem. If your not absolutely convinced that this is the best thing since the pop top beer can, maybe you'd like to see a demo of the front end . There is also a working copy of this component at VI Gallery. Here at www.swynk.com the demo is a snapshot of the utility while the VI Gallery had a SQL Server 6.5 scheduler available to show the utility in action.