Introduction to SQL Server Database Administration
Introduction to SQL Server Database Administration
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
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.