Syntax
Backing up an entire database:
BACKUP DATABASE { database_name | @database_name_var }
TO < backup_device > [ ,...n ]
[ WITH
[ BLOCKSIZE = { blocksize |
@blocksize_variable } ]
[ [ , ]
DESCRIPTION = { 'text' |
@text_variable } ]
[ [ , ]
DIFFERENTIAL ]
[ [ , ] EXPIREDATE = {
date | @date_var }
| RETAINDAYS = {
days | @days_var } ]
[ [ ,
] PASSWORD = { password | @password_variable } ]
[ [ , ] FORMAT | NOFORMAT ]
[ [ , ] { INIT | NOINIT } ]
[ [ , ] MEDIADESCRIPTION = {
'text' | @text_variable } ]
[ [ , ] MEDIANAME = { media_name
| @media_name_variable } ]
[ [
, ] MEDIAPASSWORD = { mediapassword |
@mediapassword_variable } ]
[ [ ,
] NAME = { backup_set_name | @backup_set_name_var
} ]
[ [ , ] { NOSKIP | SKIP } ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ]
]
]
Backing up specific files or filegroups:
BACKUP DATABASE { database_name | @database_name_var }
< file_or_filegroup > [ ,...n ]
TO < backup_device > [ ,...n ]
[
WITH
[ BLOCKSIZE = { blocksize |
@blocksize_variable } ]
[ [ , ]
DESCRIPTION = { 'text' |
@text_variable } ]
[ [ , ]
DIFFERENTIAL ]
[ [ , ] EXPIREDATE = {
date | @date_var }
| RETAINDAYS = {
days | @days_var } ]
[ [ ,
] PASSWORD = { password | @password_variable } ]
[ [ , ] FORMAT | NOFORMAT ]
[ [ , ] { INIT | NOINIT } ]
[ [ , ] MEDIADESCRIPTION = {
'text' | @text_variable } ]
[ [ , ] MEDIANAME = { media_name
| @media_name_variable } ]
[ [
, ] MEDIAPASSWORD = { mediapassword |
@mediapassword_variable } ]
[ [ ,
] NAME = { backup_set_name | @backup_set_name_var
} ]
[ [ , ] { NOSKIP | SKIP } ]
[ [ , ] { NOREWIND | REWIND }
]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ]
]
]
Backing up a transaction log:
BACKUP LOG { database_name | @database_name_var }
{
TO < backup_device > [ ,...n ]
[ WITH
[ BLOCKSIZE = {
blocksize | @blocksize_variable } ]
[ [ , ] DESCRIPTION
= { 'text' | @text_variable } ]
[ [ ,] EXPIREDATE
= { date | @date_var }
|
RETAINDAYS = { days | @days_var } ]
[ [ , ] PASSWORD =
{ password | @password_variable } ]
[ [ , ] FORMAT |
NOFORMAT ]
[ [ , ] {
INIT | NOINIT } ]
[ [ ,
] MEDIADESCRIPTION = { 'text' |
@text_variable } ]
[ [ , ] MEDIANAME
= { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD
= { mediapassword | @mediapassword_variable } ]
[ [ , ] NAME =
{ backup_set_name | @backup_set_name_var } ]
[ [ , ] NO_TRUNCATE ]
[ [ , ] { NORECOVERY
| STANDBY = undo_file_name } ]
[ [ , ] { NOREWIND |
REWIND } ]
[ [ , ] {
NOSKIP | SKIP } ]
[ [ ,
] { NOUNLOAD | UNLOAD } ]
[ [ , ] RESTART ]
[ [ , ] STATS [
= percentage ] ]
]
}
para el Restore
Syntax
Restore an entire database:
RESTORE DATABASE { database_name | @database_name_var }
[ FROM < backup_device > [ ,...n ] ]
[ WITH
[ RESTRICTED_USER ]
[ [
, ] FILE = { file_number | @file_number } ]
[ [ , ] PASSWORD = { password |
@password_variable } ]
[ [ , ]
MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = {
mediapassword | @mediapassword_variable } ]
[ [ , ] MOVE
'logical_file_name' TO
'operating_system_file_name' ]
[
,...n ]
[ [ , ]
KEEP_REPLICATION ]
[ [ , ] { NORECOVERY |
RECOVERY | STANDBY = undo_file_name } ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] REPLACE ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ]
]
]
Restore part of a database:
RESTORE DATABASE { database_name | @database_name_var }
< file_or_filegroup > [ ,...n ]
[ FROM < backup_device > [ ,...n ] ]
[ WITH
{ PARTIAL }
[ [ ,
] FILE = { file_number | @file_number } ]
[ [ , ] PASSWORD = { password |
@password_variable } ]
[ [ , ]
MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = {
mediapassword | @mediapassword_variable } ]
[ [ , ] MOVE
'logical_file_name' TO
'operating_system_file_name' ]
[
,...n ]
[ [ , ] NORECOVERY ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] REPLACE ]
[ [ , ] RESTRICTED_USER
]
[ [ , ] RESTART ]
[ [ , ] STATS [= percentage ] ]
]
Restore specific files or filegroups:
RESTORE DATABASE { database_name | @database_name_var }
< file_or_filegroup > [ ,...n ]
[ FROM < backup_device > [ ,...n ] ]
[ WITH
[ RESTRICTED_USER ]
[ [
, ] FILE = { file_number | @file_number } ]
[ [ , ] PASSWORD = { password |
@password_variable } ]
[ [ , ]
MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = {
mediapassword | @mediapassword_variable }
]
[ [ , ] MOVE
'logical_file_name' TO
'operating_system_file_name' ]
[
,...n ]
[ [ , ] NORECOVERY ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] REPLACE ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ]
]
]
Restore a transaction log:
RESTORE LOG { database_name | @database_name_var }
[
FROM < backup_device > [ ,...n ] ]
[ WITH
[ RESTRICTED_USER ]
[ [
, ] FILE = { file_number | @file_number } ]
[ [ , ] PASSWORD = { password |
@password_variable } ]
[ [ , ]
MOVE 'logical_file_name' TO
'operating_system_file_name' ]
[
,...n ]
[ [ , ] MEDIANAME =
{ media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = {
mediapassword | @mediapassword_variable } ]
[ [ , ] KEEP_REPLICATION ]
[ [ , ] { NORECOVERY | RECOVERY | STANDBY
= undo_file_name } ]
[ [ , ] {
NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD |
UNLOAD } ]
[ [ , ] RESTART ]
[ [ , ] STATS [= percentage ] ]
[ [ , ] STOPAT = { date_time |
@date_time_var }
| [ , ] STOPATMARK
= 'mark_name' [ AFTER datetime ]
| [ , ]
STOPBEFOREMARK = 'mark_name' [ AFTER datetime
]
]
]
