Introduction to SQL Server Database Administration
The contents include: Exactly what is a DBMS, Security Management, Introducing SQL Server Manager System (SSMS), Administrative Tasks, Adding a new user, Changing a password,Re-enabling a locked out account, Granting/Denying Access to a DB, Granting/Denying Access to a Table, Creating a New Database, Deleting a Database, Creating a Table, Quick Tutorial on Data Types, Deleting a Table, Setting the Primary Key, Backing Up the Database, Restoring a Full Backup,Database Indexes Tutorial, Data Encryption.
Author(s): Tribal Data Workshop,CRITFC, Portland, Oregon
59 Pages
Microsoft SQL Server 2000 High Availability Series
This note helps to plan and deploy a highly available data center that uses Microsoft SQL Server 2000 through proper procedures that increase availability, backups help recover from catastrophic disasters, redundant components prevent downtime, and redundant servers minimize downtime.
Author(s): Microsoft.com
NA PagesAdvertisement
