Backup and Restor a DB  
Author Message
leafboy





PostPosted: 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





PostPosted: 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





PostPosted: 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





PostPosted: 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





PostPosted: 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





PostPosted: Thu Nov 18 07:16:03 CST 2004 Top

SQL Server Developer >> Backup and Restor a DB Books Online is the SQL Server help documentation. You should find it in your
SQL Server program group. Or you can get it here:
http://www.microsoft.com/sql/techinfo/productdoc/2000/default.asp

--
David Portas
SQL Server MVP
--
 
 
Jacco





PostPosted: 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





PostPosted: 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?
>>
>>
>
>
>.
>