|
Author |
Message |
leafboy
|
Posted: Thu Nov 18 05:13:09 CST 2004 |
Top |
SQL Server Developer >> Backup and Restor a DB
Hello...
By code is there anyway to do the operations backup/restore to a SQl Server
DB?
SQL Server103
|
|
|
|
|
Dmitrij
|
Posted: Thu Nov 18 05:13:09 CST 2004 |
Top |
SQL Server Developer >> Backup and Restor a DB
Hi!!!
Use BACKUP DATABASE and RESTORE DATABASE.
BACKUP DATABASE Described:
TO < backup_device > [ ,...n ]
[ WITH
[ [ , ] DIFFERENTIAL ]
[ [ , ] FORMAT | NOFORMAT ]
[ [ , ] { INIT | NOINIT } ]
[ [ , ] { NOSKIP | SKIP } ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
]
RESTORE DATABASE Described:
[ FROM < backup_device > [ ,...n ] ]
[ WITH
[ RESTRICTED_USER ]
[ [ , ] 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 ] ]
]
For more information look in MS SQL Server help.
Dima
> Hello...
> By code is there anyway to do the operations backup/restore to a SQl Serve
r
> DB?
>
>
|
|
|
|
|
Jacco
|
Posted: Thu Nov 18 05:19:26 CST 2004 |
Top |
SQL Server Developer >> Backup and Restor a DB
See the following topics in Books Online:
"BACKUP"
"RESTORE"
--
Jacco Schalkwijk
SQL Server MVP
> Hello...
> By code is there anyway to do the operations backup/restore to a SQl
> Server DB?
>
|
|
|
|
|
mike
|
Posted: Thu Nov 18 05:19:01 CST 2004 |
Top |
SQL Server Developer >> Backup and Restor a DB
Look in Books Online for BACKUP and RESTORE
Regards
Mike
> Hello...
> By code is there anyway to do the operations backup/restore to a SQl Server
> DB?
>
>
>
|
|
|
|
|
Da
|
Posted: Thu Nov 18 06:04:06 CST 2004 |
Top |
SQL Server Developer >> Backup and Restor a DB
Thanx for the replies, now just a newbie quetion what is that Books Online
that everyone talk about?
|
|
|
|
|
REMOVE_BEFORE_REPLYING_dportas
|
Posted: Thu Nov 18 07:16:03 CST 2004 |
Top |
|
|
|
Jacco
|
Posted: Thu Nov 18 07:22:15 CST 2004 |
Top |
SQL Server Developer >> Backup and Restor a DB
You can find it in the Program group for SQL Server in the Windows start
menu, or by choosing Help (Shift-F1) within Query Analyzer. You can also
download the latest updated version from
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
--
Jacco Schalkwijk
SQL Server MVP
> Thanx for the replies, now just a newbie quetion what is that Books Online
> that everyone talk about?
>
|
|
|
|
|
anonymous
|
Posted: Thu Nov 18 12:51:51 CST 2004 |
Top |
SQL Server Developer >> Backup and Restor a DB
Go to enterprise manager. Select your database. Right
click and select all tasks->backup database.
>-----Original Message-----
>Hi!!!
>
>Use BACKUP DATABASE and RESTORE DATABASE.
>
>BACKUP DATABASE Described:
>TO < backup_device > [ ,...n ]
>[ WITH
> [ [ , ] DIFFERENTIAL ]
> [ [ , ] 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 ] ]
>]
>
>
>RESTORE DATABASE Described:
>[ FROM < backup_device > [ ,...n ] ]
>[ WITH
> [ RESTRICTED_USER ]
> [ [ , ] 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 ] ]
>]
>
>
>For more information look in MS SQL Server help.
>
>Dima
>
>
message
>> Hello...
>> By code is there anyway to do the operations
backup/restore to a SQl Serve
>r
>> DB?
>>
>>
>
>
>.
>
|
|
|
|
|
|
|