SQL Server 2000
(, Total Cost of Ownership). , . , 1015% . , . .
, , , . - . , , .
, , , , . .
, , . , . SQL Server 2000 , .
SQL Server 2000, . SQL Server 6., SQL Server 7.0 . , , . , SQL Server 2000, , . SQL Server 2000 SQLServerAgent. SQL Server 2000, . , SQLServerAgent . . , , .
|
|
, SQL Server 2000 : Jobs ; Alerts ; Operators .
SQL Server 2000 , . .
1. Wizards (). , , . , , . SQL Server 2000 :
- Create Alert Wizard ;
- Create Job Wizard ;
- Make Master Server Wizard , ;
- Make Target Server Wizard .
, . , . , , .
2. Enterprise Manager. : , , . Enterprise Manager , . Management, Enterprise Manager.
3. Transact-SQL. , . , , . . SQL Server 2000 , .
Microsoft . , SQL Server 2000. Microsoft , , . , SQL Server 2000, .
. . , .
|
|
, . , . , . , , . , , . , , , , , . .
, . , , .
, . , , . . . , , , .
, . , .
SQL Server 2000 :
- ;
- ;
- ;
- RAID ( , ), .
. , RAID (Redundant Array of Independent Disks) , . , .
. , . , , . , , (, ).
(back up) . RAID . . . . , . , . (backup), , . , . .
|
|
, . , , . . , , . , .
SQL Server 2000. - , . .
, . , , , . SQL Server 2000 . , . - , .
SQL Server 2000 , . ; ; ; .
(database backup) . , . , , , , zip-.
. , , . . , ( ), . , , , , . . , , , . , , , . , .
|
|
, , . , . , . .
, , . , . , , , , . , , SQL Server 2000 , .
, SQL Server 2000 . . .
, . :
- ;
- ;
- , , .
, . , , .
, , (differential database backup) , . , . : ; .
, . . , , . . , , . . SQL Server 2000. , . , , , , . . , .
. ( ) , ( ) . - , . .
. , , . . , . .
|
|
, , . 8 , . , , , . . , . .
(transaction log backup). , . , . , . SQL Server 2000 , .
, , . , , . . , , .
, , , , .
SQL Server 2000. , . , . , , , image, text ntext. .
SQL Server 2000 . . . . , , . , image, text ntext, .
, . , , . , , . , .
. , , . . , . , , , , . , . , . , , , . , . . . . .
, . - . , . . . . SQL Server 2000 .
. , , . , .
, . , , . , , . .
.
. . , . , . . , . .
. , , .. . , , zip-, . DVD. . SQL Server 2000 , , : , , , ..
. . , SQL Server 2000. , , , , - .
. , . , SQL Server 2000 . (named pipes) , SQL Server 2000. . SQL Server , . , , .
, . , SQL Server 2000 . Master Msdb. , .
: , , SQL Server 2000 . .
Model Tempdb. . . , . , Tempdb , SQL Server 2000. Tempdb.
, .
. , , , . . .
. SQL Server 2000, . , .
, . . , . , , , .
, , . , . .
. , . , . .
, . . . , . . . . .
, . :
) . . , , . , , - . ;
) . , . .
SQL Server 2000 . DTS . , , : , . SQL Server 2000 (replication). SQL Server 2000 . ( ), , SQL Server 2000 , . SQL Server 2000 Replication Distribution Interface. SQL Server 2000, SQL Server 7.0 SQL Server 6., , Microsoft Access, Oracle, dBase, Paradox MS Excel. .
SQL Server 2000, , , . , . - . SQL Server 2000 . SQL Server 2000 , . , , . , LAN, WAN .
SQL Server 2000 : Snapshot Agent, Log Reader Agent, Queue Reader Agent, Distribution Agent, Merge Agent.
. \ Program Files\Microsoft SQL Server\80\COM.
, , . , . , Distribution, . , , .
:
- Agent History Clean Up: Distribution;
- Distribution Clean Up: Distribution;
- Reinitialize Subscriptions Having Data Validation Failures;
- Replication Agents Checkup.
, . , , , , . . . , . , .
. , . .
. . . -, . , .
. . , . , . , , . , .
SQL Server 2000 , . , . . . .
, , , , . . , , /. , . , .
, . , , . . . , , . , .
. , .
1. . . : Performance Monitor; Task Manager; Event Viewer; Simple Network Management Protocol, SNMP.
2. SQL Server 2000 . . SQL Server 2000 : SQL Server Profiler; Enterprise Manager; Transact-SQL.
. . , , 1205, , (deadlocks). , , , . , , , . . . , . , , .
SQL Server 2000
SQL Server 2000 (events). SQL Server 2000 , . - (event classes), . SQL Server . (category):
1. Sessions. , .
2. Objects. , , , .
3. Scans. , , , .
4. TSQL. , Transact-SQL.
5. Cursors. , .
6. Stored Procedures. , .
7. Error and Warning. , SQL Server 200C.
8. Transactions. , , SQL Serve MSDTC, .
9. Locks. , .
10. Databases. , .
11. Performance. , , , . .
12. Server. , , MSSQLServer.
13. Security Audit. , .
14. User Configurable. , .
Master. . . , . , . (Null).