Datasheet

Finer Grained Online Repairs: You can restore data filegroup by file-
group with the database being available after the primary filegroup is
restored.
Enhanced Backup Verification: The verifying of backups is more com-
plete than in previous versions of SQL Server. The RESTORE VERIFY
ONLY syntax checks everything that can be checked, short of writing the
backup to the server.
Backup Media Mirroring: This allows you to make extra copies of back-
ups to minimize the chance of a failed restore or to make an archival
copy for offsite storage, for example.
Database Page Checksums: Checksums are added to individual pages in
the database to detect errors that otherwise might go undetected.
Backup Checksums: Adds an additional error detection mechanism
during backup. It is possible to proceed past errors and fix them later.
Backup Data and Logs: The former problems with log backups at the same
time as data backups have been remedied. It is now possible to carry out a
data backup at the same time as the corresponding log backup.
Scalability Enhancements
One of the key aims of SQL Server 2005 is to improve the scalability of data-
bases and the applications that depend on them.
Installing in a cluster
You can install SQL Server 2005 in a cluster of up to eight nodes with status
reporting of install progress on each node. SQL Server 2005 setup has the
ability to install Analysis Services in a cluster. New in SQL Server 2005 is the
ability to carry out unattended installation to a cluster.
Partitioning data
Some database objects are very large. Partitioning splits large database
objects into multiple more manageable pieces. Suppose you have a huge
table that contains many months of data. You could improve performance by
partitioning the table into several smaller partitions with each partition con-
taining the data for a single month.
31
Chapter 2: New Features in SQL Server 2005
06_577557 ch02.qxp 12/20/05 9:43 PM Page 31