Row Compression Implementation

This topic summarizes how the Database Engine implements row compression. This summary provides basic information to help you plan the storage space that you need for your data. Enabling compression only changes the physical storage format of the data that is associated with a data type but not its syntax or…

Page Compression Implementation

This topic summarizes how the Database Engine implements page compression. This summary provides basic information to help you plan the storage space that you need for your data. Note The details of data compression are subject to change without notice in service packs or subsequent releases. Page compression is similar for tables,…

Setting Server Configuration Options

You can manage and optimize SQL Server resources through configuration options by using SQL Server Management Studio or the sp_configure system stored procedure. The most commonly used server configuration options are available through SQL Server Management Studio; all configuration options are accessible through sp_configure. Consider the effects on your system…

RESTORING ACTIVE DIRECTORY USING WBADMIN AND NTDSUTIL

You can use wbadmin, which is the command-line component of the WindowsServer Backup snap-in, to perform a nonauthoritative restore of Active Directory, which restores a single Active Directory domain controller to its state before the backupwbadmin start sysstaterecovery -version:MM/DD/YYYY-HH:MM-backuptarget:targetDrive:-machine: BackupComputerName-quiet Rebooted your domain controller intoDirectory Services Restore Mode, and that you have already…

Windows 2008 backup with wbadmin & ntdsutil

Open the command prompt: C: ntdsutilntdsutil: help -> to access the help filesntdsutil: IFMntdsutil: Activate Instance NTDSntdsutil: IFMifm: help -> to access the help filesifm: Create Full %s(the backup folder name) C: wbadmin start systemstatebackup -backupTarget:d(the backup drive): wbadmin restoreC: wbadmin get versionsC: wbadmin start systemstaterecovery version: (location)C: ntdsutil ntdsutil: activate…

Windows Server 2008 R1 Edition Comparison

Windows Server 2008 comes in several major editions derived from the same code base. The most important differences among editions are in the number of processors, amount of physical memory, and high-availability features supported. The edition specifically targeted at servers with Itanium CPUs, Windows Server 2008 for Itanium-Based Systems (IA64),…

How the Global Catalog Works

Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2, Windows Server 2008, Windows Server 2008 R2 In a multidomain Active Directory® Domain Services (AD DS) forest, the global catalog provides a central repository of domain information for the forest by storing…