|
|
HOME
>
CHAPTER 7
Chapter 7: SQL
Server 2000
Like ISA
Server 2000, SQL Server 2000 is available only in the premium version of
SBS 2003. You will find SQL Server 2000 on the Windows Small Business
Server Premium Technologies CD.
SQL Server can be used as a database for your business applications. You
can, however, update the copy of MSDE (Microsoft SQL Server Desktop
Engine) used by the SharePoint Services. It is also possible to use only
MSDE instead of SQL Server if the company's requirements do not exceed
its functional scope.
Without databases, it is virtually impossible to manage information and
tasks within an organization. By structuring the data, you can ensure
effective access to it for all areas and employees of the organization.
The implementation of the database environment consists of several
steps. If no database has been implemented in the organization so far,
you must first formulate a plan for the database to be installed. The
more careful you are with this plan, the more effectively can you use
the data later. After the planning stage, SQL Server is installed and
the individual databases created. To ensure that the database is always
current, it needs to be maintained, updated, and administered.
- Organization of the Database
- Database on a Server
- Client-Server Database Solution
- Client Access to the Database
- The Design of the Database
- The Installation of SQL Server 2000
- Installing a New Instance of SQL Server 2000
- Installing Service Pack 3a for a New Instance
- Problems with the Service Pack Installation
- Updating the MSDE Instance Used by SharePoint Services
- Installing Service Pack 3a for the SHAREPOINT Instance
- Sorting Settings for SQL Server 2000
- Checking the Sort Orders of other SQL Servers
- The Databases of SQL Server
- The Structure of a Database
- Enterprise Manager
- Starting Services and Instances
- Installing an Existing Database
- Service Programs of SQL Server
- SQL Server Network Utility
- SQL Server Client Network Utility
- Permissions for Database Access
- Authentication on the Database
- Permissions on the Database
- Permissions through Roles
- Database Roles
- Server Roles
- Configuring Permissions for a User
- Further Configuration Options for Permissions
- Creating and Adding a Database User
- Creating Additional Database Roles
- Issuing Permissions
- Backing Up and Restoring the Database
- Types of Backup
- Complete Database Backup
- Differential Database Backup
- Transaction Log Backup
- File and File-Group Backup
- Creating a Backup
- The Backup Wizard and Manual Backup
- The Backup Wizard
- Manual Backup
- Modifying Backup Tasks
|
 |
|
 |
| |
Paperback,
494 pages
Release date: August 2005
ISBN: 1904811493
Author: Stephanie Knecht-Thurmann |
|
|
|
|
|
Introduction
Chapter 1: Introduction to Small
Business Server 2003
Chapter 2: Installing SBS 2003
Chapter 3: Upgrade and Migration
Chapter 4: Exchange Server 2003 and
Fax Services
Free Chapter
Chapter 5: Windows SharePoint
Services 2.0
Chapter 6: Internet Security and
Acceleration Server 2000 (ISA)
Chapter 7:SQL Server 2000
Chapter 8: SBS 2003 Administration
Chapter 9: Update Management in the
SBS Network through Software Update Services Server (SUS)
Chapter 10: Terminal Server in an
SBS 2003 Environment
Chapter 11: Business Contact Manager
2003
Chapter 12: A Security Strategy for
SBS 2003
Chapter 13: Troubleshooting Small
Business Server 2003
Index
|
 |
|
View the book details
on PacktPub.com
|
|
