Updated: November 14, 2012
Applies To: Windows Server 2008, Windows Server 2012, Windows 8
Performs recovery, bringing all databases to a clean-shutdown state.
For examples of how to use this command, see Examples.
Parameter: <3-character logfile base name>
<options>: You can specify zero or more of the options that are listed in the following table. Separate each option with a space.
Location of log files (default: current directory)
Location of system files (for example, the checkpoint file) (default: current directory)
Ignore mismatched/missing database attachments
On successful recovery, truncate log files
Stop recovery when the Undo phase is reached with the option to stop when a certain log generation is recovered. [log] is the log generation number and if not specified the replay will go the end of the existing logs.
Location of database files or current directory if [path] not specified. (default: directory originally logged in log files)
New location of database file and optional old location if the database file location changed.
Can be specified for each database file.
If a certain database is not in the list, it will not get recovered.
To allow recovery in the original location for all other databases, use n* (not valid with /d switch; not valid with /b switch).
Allow recovery to lose committed data if database integrity can still be maintained.
Sets the database page size to 2k. The default is auto-detect.
Sets the database page size to 4k. The default is auto-detect.
Sets the database page size to 8k. The default is auto-detect.
Sets the database page size to 16k. The default is auto-detect.
Sets the database page size to 32k. The default is auto-detect.
Suppresses the logo.