Datasheet

Full-text search
You can back up and restore Full-text Search catalogs (the databases where
the metadata is stored) in the same way as you back up and restore any
other SQL Server 2005 databases.
SQL Server Service Broker
SQL Server Service Broker allows you to create asynchronous message-based
applications. The asynchronous nature of Server Broker messages means
that processing tasks needn’t be done all at the same time, which can slow
the server down. Instead, messages are queued for processing when the
server load is lighter, improving overall performance.
Turn to Chapter 19 for more info on Service Broker.
Dedicated Administrator connection
This is not a connection only for dedicated administrators but a connection
that only administrators can use. The connection is used when a runaway
process is on the server and you need access to the database engine to kill
the process. Even if the runaway process is using close to 100 percent of the
CPU cycles, the Dedicated Administrator connection allows administrators to
get a share of CPU cycles and so kill the runaway process. This capability
allows you to kill a runaway process without having to restart the server.
SQLCMD
The SQLCMD command-line utility is the recommended command-line tool in
SQL Server 2005. You can write SQLCMD commands individually or use
SQLCMD to execute T-SQL scripts.
The SQLCMD utility allows you to use command-line parameters to replace vari-
ables in a T-SQL script. For example, suppose you had a simple backup script
BACKUP DATABASE $(db) TO DISK = “$(path)\$(db).bak”
called backup.sql. It backs up a specified database to a specific location.
You can run that script from the command line, replacing the $db and $path
variables with the relevant database name and file path. For example, to back
up AdventureWorks into the C:\Backups folder, you write:
sqlcmd -E -i Backup.sql -v db=”AdventureWorks”
path=”C:\Backups”
28
Part I: SQL Server 2005: An Overview
06_577557 ch02.qxp 12/20/05 9:43 PM Page 28