databasejournal.com databasejournal.com

Microsoft SQL Server 2000 command line utilities (Part 2)

This article is a continuation of "Microsoft SQL Server 2000 command line utilities (Part 1)," which began our discussion of how to use the Microsoft SQL Server 2000 command line utilities, and what are they used for. . Most of these utilities are primarily used for diagnostic, configuration and data migration purposes, rather than for database server administration. Profiler - Profiler is the executable for SQL Server Profiler....

databasejournal.com databasejournal.com

Microsoft SQL Server 2000 command line utilities (Part 1)

This first article in a series of two, discusses how to use the Microsoft SQL Server 2000 command line utilities, and what are they used for. Just to be clear before I start, these utilities are primarily used for diagnostic, configuration and data migration purposes, rather than for database server administration. Please find below all the 42 command line utilities available in an SQL Server instance. Some of the tools...

databasejournal.com databasejournal.com

SQL Server Agent - Creating Performance Condition Alerts on Database Server Objects

In my previous articles we discussed the SQL Server Agent subsystem and one of its components, alerts. In this the fifth article in the series, we discover that the DBA can select among two types of alerts: SQL Server event alerts and SQL Server performance condition alerts. My next article, "Creating alerts on database server performance condition with Performance Monitor", will describe how DBAs can implement general...

databasejournal.com databasejournal.com

SQL Server Database Monitoring - Recovery from 1105 and 9002 Errors

This article is the fourth in a series focusing on alerts and errors within the SQL Server Agent subsystem. In this article I am going to detail how to recover from SQL Server 1105 / 9002 errors. This article will also describe monitoring and recovery procedures for SQL Server databases. I am also planning to periodically publish additional guides to ensuring the health of Microsoft SQL Server and its databases. Database Files...

databasejournal.com databasejournal.com

Microsoft SQL Server 7.0 Administrative Command Line Utilities (Part 2)

Now we continue covering Microsoft SQL Server command line utilities as started in Part 1 of this article. Let's jump right in ... Replupd - Part of the SQL Server replication subsystem, Replupd is used for transferring replication parameters from previous versions of SQL Servers (v6.x). Scm - A utility used to start/stop SQL Server and/or Microsoft Data Engine (MSDE) services from a command prompt or a batch file (similar to...