June 1, 2008 at 5:15 am
Hello,
can any one tell difference between backup database of
format/noformat, skip/noskip, init /noinit, status i have read books online
it no clear.
Regards,
sathish.
June 2, 2008 at 12:34 am
FORMAT
Specifies that a new media set be created. FORMAT writes a new media header on all volumes used for this backup operation, overwriting any existing media header and backup sets. The FORMAT option invalidates the entire existing media contents.
Important:
Use FORMAT carefully. Formatting one backup device or medium renders the entire media set unusable. For example, if you initialize a single tape belonging to an existing striped media set, the entire media set is rendered useless.
Specifying FORMAT implies SKIP; SKIP does not need to be explicitly stated.
NOFORMAT
Specifies that the media header should not be written on all volumes used for this backup operation. This is the default behavior.
INIT
Specifies that all backup sets should be overwritten, but preserves the media header. If INIT is specified, any existing backup set on that device is overwritten.
By default, BACKUP checks for the following conditions and does not overwrite the backup media if either condition exists:
Any backup set has not yet expired. For more information, see the EXPIREDATE and RETAINDAYS options.
The backup set name given in the BACKUP statement, if provided, does not match the name on the backup media. For more information, see the NAME clause.
To override these checks, Use the SKIP option. For more information about interactions between { INIT | NOINIT } and { NOSKIP | SKIP }, see the Remarks section.
Note:
If the backup media is password protected, SQL Server does not write to the media unless the media password is supplied. This check is not overridden by the SKIP option. Password-protected media may be overwritten only by reformatting it. For more information, see the FORMAT option.
NOINIT
Indicates that the backup set is appended to the specified media set, preserving existing backup sets. NOINIT is the default. For information on the interactions between { INIT | NOINIT } and { NOSKIP | SKIP }, see the Remarks section.
The FILE option of the RESTORE command is used to select the appropriate backup set at restore time. For more information, see RESTORE.
If a media password is defined for the media set, the password must be supplied.
NOSKIP
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. For information about the interactions between { INIT | NOINIT } and { NOSKIP | SKIP }, see the Remarks section.
SKIP
Disables the checking of backup set expiration and name that is usually performed by the BACKUP statement to prevent overwrites of backup sets. For information about the interactions between { INIT | NOINIT } and { NOSKIP | SKIP }, see the Remarks section.
June 3, 2008 at 2:00 pm
Check with Books Online of SQL 2000 and 2005 as well.
MCP, MCTS (GDBA/EDA)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply