Chapter 13 — Operation
Published: June 21, 2004 | Updated: October 29, 2004
On This Page
This chapter provides links to guidance for database administrators and database support personnel on the operation of Microsoft® SQL Server™ 2000 in your organization. Your requirements may vary based on the specific implementation and deployment of SQL Server in your environment.
Note The information in this chapter is intended for IT professionals competent in matters of database support and critical areas of database administration. Training may be necessary for anyone to carry out the tasks and procedures described here or in reference documents. This guidance does not dictate support policies for your organization and the subjects discussed do not address all of the potential issues that can arise in support of a database enterprise environment.
The following links provide conceptual content of particular relevance to operations:
Operating system. See "Safeguarding Your System" at http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/serverhelp/EB397B22-AA00-4BEB-9FEA-F7E7A0CB706B.mspx.
Database. See "Managing Security" at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_05bt.asp.
Operating system. See "Common Administrative Tasks" at http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/serverhelp/F2D54234-6D65-439B-9D3B-AC1C4B2A3F99.mspx.
Database. See "Administration" at http://www.microsoft.com/sql/techinfo/administration/2000/default.asp.
Monitoring and control —operating system:
Network. See "Monitoring Network Traffic" at http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/serverhelp/B142133D-2F46-4543-A977-B4DEEE98C183.mspx.
Performance. See "Monitoring Server Performance" at http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/serverhelp/8368DFD6-0D42-4FC7-B0AC-D331EE33BE43.mspx.
Security. See "Monitoring Security-related Events" at http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/serverhelp/BC9F1BED-1C85-413A-869E-98D467853978.mspx.
Monitoring and control — database:
- Performance and activity. See "Monitoring Server Performance and Activity" at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_mon_perf_00mr.asp.
Capacity and storage management:
Operating system. See "Managing Disks and Volumes" at http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/serverhelp/D773121A-DE0D-4795-B9AA-40A1202FAE72.mspx.
Database. See "Maximum Capacity Specifications" at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp.
Operating system. See "Managing Services" at http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/serverhelp/DC8EE28B-13C9-4E4F-BEAA-F9AEED6C1D54.mspx.
Database servers. See "Managing Servers" at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8fhv.asp.
Clients. See "Managing Clients" at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_client_5er7.asp.
The links to content associated with logical elements of the production environment contain largely procedural information. The following links contain day-to-day operations-oriented content.
Operating system. See "Troubleshooting Strategies" at http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/serverhelp/8DD5DD9E-D163-4260-BC9D-3286AF55BAD3.mspx.
Database. See "Troubleshooting Overview" at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_hightrbl_6nxz.asp.
Operating system. See "Windows Server 2003 Events and Errors" at http://www.microsoft.com/technet/support/ee/ee_advanced.aspx
Database. See "Viewing Error Logs" at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_hightrbl_3fw3.asp.
- Database. See "Replication Overview" at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replover_694n.asp.
Backup and restore:
Operating system. See "Backing Up and Restoring Data" at http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/serverhelp/B31F6643-746D-43DB-9AC3-93ABAAE7D75F.mspx.
Database. See "Backing Up and Restoring Databases" at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_9zcj.asp.
The Sybase platform from which you are migrating may have methods already established for performing routine system operations such as backup and restore. In that case, the information made available through these Web links should assist you in identifying and understanding parallels for those methods in the SQL Server environment.
It is likely that many of your existing Sybase maintenance methods and procedures are based on UNIX scripts. Some information in this chapter presents opportunities for you to use these existing UNIX scripting methods by editing the scripts to call the equivalent commands from SQL Server or by using support tools such as Windows Services for UNIX 3.5, which may require only minor changes to the scripts. This script reuse methodology is a powerful way to use existing methodologies during migration and often for ongoing operations. For more complete information about UNIX scripting and migration, consult the UNIX Application Migration Guide. For detailed information about the features of Windows Services for UNIX, see http://www.microsoft.com/windows/sfu/.
The standard framework for presenting Microsoft operations-related guidance is the Microsoft Operations Frameworks (MOF). The cited references may refer to concepts on which the framework is based, such as conceptual and logical elements of a system. For an introduction to the underlying principles of MOF, see the MOF Executive Overview white paper on the Microsoft TechNet Web site at
http://www.microsoft.com/technet/itsolutions/cits/mo/mof/mofeo.mspx. Information about MOF in the context of operations is also available in Chapter 1 of the Microsoft SQL Server 2000 Operations Guide.
For information about TechNet and viewing the MSDN library, see:
The Microsoft TechNet page, at
The MSDN SQL Server page at http://msdn.microsoft.com/sqlserver.