Learn MS SQL 7.0 Administration
Systems administrators often have two basic questions:
"What do I need to do to keep the system running smoothly?"
"What do I do if something goes wrong?"
"Learn SQL Server 7.0 Administration" answers the first question in detail, with the expectation that this will prevent the second question from being asked.
To achieve this goal, SQL Server consultant Jeffrey Garbus provides detailed information about designing and implementing a preventive maintenance regimen in order to ensure ongoing reliability, performance, and preparedness for disaster recovery. The book opens by introducing basic concepts, then quickly progresses to such advanced topics as configuring SQL Server for optimum performance, monitoring activity on the server, using the Database Consistency Checker, and backing up and restoring the database. Updating index statistics, using wizards to automate tasks, and replicating data are also covered.
Garbus' book is for anyone who must learn to maintain a SQL Server.
Jeffrey Garbus is an experienced SQL Server 7.0 consultant. He has spoken at user conferences, written many magazine articles, and has several SQL and database books to his credit. He is the CEO of Soaring Eagle Consulting, Ltd., based in Florida.
Alvin Chang is a consultant for Soaring Eagle Consulting, and Penny Garbus is president of Soaring Eagle Consulting.
What people are saying - Write a review
We haven't found any reviews in the usual places.
A Preventive Maintenance Regimen
12 other sections not shown
Other editions - View all
alert AutoCAD LT automatically backup database backup device backup file backup media Backup set Backup Wizard button Cancel Help choose Click OK command complete configuration option Console Root Data Transformation Services database backup database files Database Maintenance Plan Day Learn DBCC results dbo authors KEY default differential backup DirectX disk Enterprise Manager error messages hardware Index ID KEY X GRANT Learn Microsoft log file Logins Maintenance Plan Wizard megabytes Microsoft SQL Server monitor msdb NOJNFOMSGS Northwind Notifications pages for object performance problem Programming Publishing pubs dbo authors pubsnew Query Analyzer Remote Servers rows RYO-OHKI Schedule Select Specify spid spidl SQL Server 7.0 SQL Server Agent SQL Server Group Stored Procedures Subscribers system administrator tape tasks tempdb Transact-SQL transaction log backup Transactional replication Type UPDATE STATISTICS virtual memory Windows 95 Windows NT Wizard SOARINGEAGLETWO