Текущий архив: 2007.02.11;
Скачать: CL | DM;

Вниз

Как востановить БД, из backup, под другим именем   Найти похожие ветки 

← →
Rtn   (2007-01-18 14:21) [0]

MSSQL 2000.
???

---

← →
Ega23 ©   (2007-01-18 14:27) [1]


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 ]
   ]
]

< backup_device > ::=
   {
       { "logical_backup_device_name" | @logical_backup_device_name_var }
       | { DISK | TAPE } =
           { "physical_backup_device_name" | @physical_backup_device_name_var }
   }

< file_or_filegroup > ::=
   {
       FILE = { logical_file_name | @logical_file_name_var }
       |
       FILEGROUP = { logical_filegroup_name | @logical_filegroup_name_var }
   }



---

Страницы: 1 вся ветка

Текущий архив: 2007.02.11;
Скачать: CL | DM;

Наверх

Память: 0.48 MB
Время: 0.052 c