Las operaciones de opciones se informan a irself


En este tema se aplica a: Startup options designate certain file locations needed during startup, and specify some server wide conditions. Most users do not need to specify startup options unless you are troubleshooting the Motor de base de datos Database Engine or you have an unusual problem and are directed to use a startup option by SQL Server SQL Server Customer Support.

Puede utilizar estas opciones de inicio para especificar un archivo alternativo para la base de datos maestra, el archivo de registro de la base de datos maestra o un archivo de registro de errores. You can use these startup options to specify an alternate master database file, master database log file, or error log file.

Some startup options, such as single-user mode and minimal configuration mode, are principally used during troubleshooting. Starting the server for troubleshooting with the —m or —f options is easiest at the command line, while manually starting sqlservr. Esta herramienta guarda las opciones de inicio como claves del Registro, lo que habilita que SQL Server SQL Server siempre se inicie con las opciones de inicio activadas.

Ruta de acceso completa del archivo de base de datos maestra normalmente, C: Is the fully qualified path for the master database file typically, C: If you do not provide this option, the existing registry parameters are used.

Ruta de acceso completa del archivo de registro de errores normalmente, C: Is the fully qualified path for the error log file typically, C: Ruta de acceso completa del archivo de registro de la base de datos maestra normalmente, C: Is the fully qualified path for the master database log file typically C: If you do not specify this option, the existing registry parameters are used.

This is useful if the setting of a configuration value for example, over-committing memory has prevented the server from starting. For more information, see the description for -m that follows.

El valor predeterminado es MB. The default is MB. Use of this option might help tune memory allocation, but only when physical memory exceeds the configured limit set by the operating system on virtual memory available to applications. En este caso, considere la posibilidad de aumentar la cantidad de memoria reservada con el modificador -g.

In this case, consider increasing the amount of memory reserved by the -g switch. Using a value lower than the default will increase the amount of memory available to the memory pool managed by the SQL Server Memory Manager and thread stacks; this may, in turn, provide some performance benefit to memory-intensive workloads in systems that do not use many extended stored procedures, distributed queries, or automation objects.

Typically, this option is used if you experience problems with system databases that should be repaired. By default, allow updates is disabled. Limits the connections to a specified client application. Use this option when you are starting SQL Server SQL Server in single-user mode and an unknown client application is taking the only available connection. Client Application Name is case sensitive. Double quotes are required if the application name contains spaces or special characters.

Examples when starting from the command line: Do not use this option as a security feature. The client application provides the client application name, and can provide a false name as part of the connection string.

Without the -s parameter set, the default instance will try to start. You must switch to the appropriate BINN directory for the instance at a command prompt before starting sqlservr. Las marcas de seguimiento se utilizan para iniciar el servidor con un comportamiento distinto del habitual. Trace flags are used to start the server with nonstandard behavior.

When specifying a trace flag with the -T option, use an uppercase "T" to pass the trace flag number. Parameters specified in the Control Panel startup window are not read. Disables the following monitoring features: When you use the —x startup option, the information that is available for you to diagnose performance and functional problems with SQL Server SQL Server is greatly reduced. Increases the number of extents that are allocated for each file in a filegroup.

This option may be helpful for data warehouse applications that have a limited number of users running index or data scans. It should not be used in other applications because it might adversely affect performance.

Specifies a complete database backup. Si se especifica una lista de archivos y grupos de archivos, solo se realiza la copia de seguridad de esos archivos o grupos de archivos. If a list of files and filegroups is specified, only those files and filegroups are backed up. Durante una copia de seguridad completa o diferencial de una base de datos, SQL Server SQL Server realiza la copia de seguridad de una parte suficiente del registro de transacciones para producir una base de datos coherente cuando se restaure la base de datos.

During a full or differential database backup, SQL Server SQL Server backs up enough of the transaction log las operaciones de opciones se informan a irself produce a consistent database when the backup is restored.

Only a log backup can be restored to a specific time or transaction within the backup. Solo se puede realizar una copia de seguridad completa de la base de datos maestra.

Only a full database backup can be performed on the master database. Specifies a backup of the transaction log only. The log is backed up from the last successfully executed log backup to the current end of the log. Para poder crear la primera copia de seguridad de registros, debe crear una copia de seguridad completa. Before you can create the first log backup, you must create a full backup. The log is truncated after all the records within one or more virtual log files become inactive.

If the log is not being truncated after routine log backups, something might be delaying log truncation. For more information, see Factors that can delay log truncation.

The mirror database in a database mirroring partnership cannot be backed up. Is the logical name of a file or a variable whose value equates to the logical name of a file that is to be included in the backup. Is the logical name of a filegroup or a variable whose value equates to the logical name of a filegroup that is to be included in the backup. Under the simple recovery model, a filegroup backup is allowed only for a las operaciones de opciones se informan a irself filegroup.

Consider using file backups when the database size and performance requirements make a database backup impractical. The NUL device can be used to test the performance of backups, but should not be used in production environments. Is a placeholder that indicates that las operaciones de opciones se informan a irself files and filegroups can be specified in a comma-separated list.

The number is unlimited. Specifies a partial backup. Is the logical name of a read-only filegroup or a variable whose value equates to the logical name of a read-only filegroup that is to be included in the partial backup. Is a placeholder that indicates that multiple read-only filegroups can be specified in a comma-separated list.

The logical name must follow the las operaciones de opciones se informan a irself for identifiers. Specifies a disk file or tape device, or a Windows Azure Blob storage service.

Para ver un tutorial, vea Tutorial: For a tutorial, see Tutorial: The NUL disk device will discard all information sent to it and should only be used for testing. This is not for production use. A partir de SQL Server Starting with SQL Server Para hacer una copia de seguridad en varios dispositivos cuando se hagan copias de seguridad en URL, hay que usar las versiones SQL Server URL se aplica a: The NUL device will discard all input sent to this file, however the backup will still mark all pages as backed up.

Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Is a placeholder that indicates that up to 64 backup devices may be specified in a comma-separated list. Specifies options to be used with a backup operation.

Used only when creating a backup to the Windows Azure Blob storage service. Used to create an Azure snapshot of the database files when all of the SQL Server database files are stored using the Azure Blob storage service. A consistent set of Azure snapshots make las operaciones de opciones se informan a irself a backup and are recorded in the backup file.

Furthermore, only two transaction log backups are required to restore a database to a point in time between the time of the two transaction log backups. Una copia de seguridad diferencial suele ocupar menos espacio que una copia de seguridad completa.

A differential backup usually takes up less space than a full backup. Use this option so that las operaciones de opciones se informan a irself individual log backups performed since the last full backup do not have to be applied. Used to specify encryption for a backup. Encryption is recommended practice to help secure backup files. La lista de algoritmos que puede especificar son: The list of algorithms you can specify are: If you choose to encrypt you will also have to specify the encryptor using the encryptor options: No additional encryption happens for the data itself.

The backup fails if the database was not encrypted or if the encryption was not completed before the backup statement was issued. Opciones de conjunto de copia de las operaciones de opciones se informan a irself Backup Set Options.

These options operate on the backup set that is created by this backup operation. Specifies that the backup is a copy-only backupwhich does not affect the normal sequence of backups. Se las operaciones de opciones se informan a irself una copia de seguridad de solo copia independientemente de las las operaciones de opciones se informan a irself de seguridad convencionales programadas regularmente.

A copy-only backup is created independently of your regularly scheduled, conventional backups. A copy-only backup does not affect your overall backup and restore procedures for the database. Copy-only backups should be used in situations in which a backup is taken for a special purpose, such as backing up the log before an online file restore. Normalmente, una copia de seguridad de solo copia se usa una vez y se elimina.

Typically, a copy-only log backup is used once and then deleted. El mapa de bits diferencial no se actualiza y las copias de seguridad diferenciales se comportan como si no existiera la copia de seguridad de las operaciones de opciones se informan a irself copia.

The differential bitmap is not updated, and differential backups behave as if the copy-only backup does not exist. Subsequent differential backups use the most recent conventional full backup as their base. La copia de seguridad del registro de solo copia no afecta a la cadena de registros y otras copias de seguridad del registro se comportan como si no existiera la copia de seguridad de solo copia.

The copy-only log backup has no effect on the log chain, and other log backups behave as if the copy-only backup does not exist. At installation, the default behavior is no backup compression.

But this default can be changed by setting the backup compression default server configuration option. Explicitly enables backup compression. Explicitly disables backup compression. Specifies the free-form text describing the backup set. The string can have a maximum of characters. Specifies the name of the backup set. Names can have a maximum of characters. If NAME is not specified, it is blank.

Specifies when the backup set for this backup can be overwritten. If neither option is specified, the expiration date is determined by the mediaretention configuration setting. Tapes can be erased using other methods, and disk files can be deleted through the operating system. For information about how to specify datetime values, see Date and Time Types. To ignore the expiration date, use the SKIP option. Opciones de conjuntos de medios Media Set Options.

Estas opciones funcionan para todo el conjunto de medios. These options operate on the media set as a whole. Controls whether the backup operation appends to or overwrites the existing backup sets on the backup media.

Indicates that the backup set is appended to the specified media set, preserving existing backup sets. If a media password is defined for the media set, the password must be supplied. Specifies that all backup sets should be overwritten, but preserves the media header.

Si se especifica INIT, se sobrescriben todos los conjuntos de copia de seguridad existentes en el dispositivo, si las condiciones lo permiten. If INIT is specified, any existing backup set on that device is overwritten, if conditions permit.

De forma predeterminada, BACKUP comprueba las siguientes condiciones y no sobrescribe los medios de copia de seguridad en caso de existir alguna de las condiciones siguientes: By default, BACKUP checks for the following conditions and does not overwrite the backup media if either condition exists: To override these checks, use the SKIP option.

Controls whether a backup operation checks the expiration date and time of the backup sets on the media before overwriting them. Instructs the BACKUP statement to check the expiration date of all backup sets on the media before allowing them to be overwritten. This is the default behavior.

Disables the checking of backup set expiration and name that is usually performed by the BACKUP statement to prevent overwrites of backup sets. Specifies whether the media header should be written on the volumes used for this backup operation, overwriting any existing media header and backup sets.