Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Sep 7, 1999

Centralized Administration in a Distributed Environment (ASP and SQL Server)

By Bill Wunder

?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.

      There have not been many changes to the original information posted on the vast expanse for over a year in the interest of keeping it simple. At the same time, the admin subsystem has evolved. What you'll find posted here is a distributed SQL Server 6.5 administration utility that plays with ASP, ADO, JavaScript, DHTML, Stored Procedures, TSQL scripts, Triggers, and the NT command line to enable an albatross grade Administrator to get the job done. The tasks are table driven and the enrollment of remote servers is automated from an ASP page. The result is an administration tool that is slightly more difficult to set up because it is more complex yet extremely flexible and easy to use once in place.

      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.

      Download the complete admin subsystem with installation instructions.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM