Chapter Download: Essential SQL Server 2000 maintenance

The primary tool described here for database maintenance is the Database Maintenance Wizard. This graphical tool walks you through setting up a scheduled plan that can include integrity checks, optimizations, and backups. The second set of tools are the T-SQL Database Consistency Check (DBCC) commands. They perform maintenance tasks on a database or an index, as well on filegroups.

Click here to download this free book chapter.

Click here for more information on Addison-Wesley Professional, the author, or to buy the book.

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SQL/Transact SQL (T-SQL) Using DELETE and TRUNCATE TABLE statements to delete data in SQL Server SQL language crash course (just enough to be dangerous) Working with IntelliSense in SQL Server 2008 Management Studio SQL Server Mailbag: Stored procedures, triggers and SSRS reports Working with sparse columns in SQL Server 2008 Determining the source of full transaction logs in SQL Server New GROUP BY option provides better data control in SQL Server 2008 Using the OPENROWSET function in SQL Server Loading data files with SQL Server's BULK INSERT statement Importing and exporting bulk data with SQL Server's bcp utility SQL/Transact SQL (T-SQL) Research SQL Server Backup and Recovery SQL Server Mailbag: Data restoration and DB property management Achieving high availability and disaster recovery with SharePoint databases How to 'do' SQL Server disaster recovery The keys to database backup protection for SQL Server Choosing a SQL Server disaster recovery solution Licensing a standby server for SQL Server replication Can I encrypt and restore a database backup in SQL Server 2005? SQL Server errors, failures and other problems fixed from the trenches Get SQL Server log shipping functionality without Enterprise Edition SQL Server 2008 backup compression pros and cons SQL Server Backup and Recovery Research Microsoft SQL Server 2000 Track changes to SQL Server 2000 and 2005 with one simple utility Is it possible to find disabled indexes in SQL Server 2000? FAQ: Creating and altering SQL Server tables FAQ: SQL Server comparison features SQL Server DBMS' growing popularity is no coincidence What is a SQL Server instance? Strange error when installing SQL Server 2000 Developer Edition Working with multiple versions of SQL Server Setting up automatic switchover between SQL Server instances Test for hardware problems with PHYSICAL_ONLY Microsoft SQL Server 2000 Research

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary ACID  (SearchSQLServer.com) Collaboration Data Objects  (SearchSQLServer.com) commit  (SearchSQLServer.com) container  (SearchSQLServer.com) DAO  (SearchSQLServer.com) fetch  (SearchSQLServer.com) OLE DB  (SearchSQLServer.com) query  (SearchSQLServer.com) SQL  (SearchSQLServer.com) T-SQL  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary