|
Provided by: 123-CBT Computer Based Training Backing Up SQL Server 2000 Databases |
![]() |
Training
Provided by 123-CBT Computer Based Training
To explain how to back up SQL Server databases
|
|
||||||||
Backing Up SQL Server 2000 Databases
Overview:
To explain how to back up SQL Server databasesPre-Requisites:
Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one year?s experience administering SQL Server; at least one year?s experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM , databases as large as 2 TB, and multiple installations of SQL Server 2000Target Audience:
Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise EditionModality:
WEBLesson:
Preventing a disaster in SQL Server 2000| - explain why backups are necessary, when to perform backups, and what activities are restricted during backups.|Backing up in SQL Server 2000| - describe backup options in SQL Server 2000 and use the BACKUP command.|Creating permanent and temporary backup files| - create a permanent or temporary backup file that will contain the actual backup.|Creating a temporary backup file in SQL Server 2000| - create a temporary backup file using Enterprise Manager.|Implementing a backup strategy| - perform a SQL Server backup using Enterprise Manager.|Performing a full backup in SQL Server 2000| - perform and schedule a full backup using Enterprise Manager.|SQL Server 2000 backup strategies| - plan a backup solution using one or more of the backup strategies provided by SQL Server 2000.|Optimizing SQL Server 2000 backups| - describe how to optimize SQL Server 2000 backups.|
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...

