Is it possible to make a backup from MSDE ?? (Y/N)
The problem: I am going to develop an application for a small company and it don't like to spend more $$ rather than some $$ for the App.
So, I don't know if it is possible to do a backup from MSDE or not?
BTW: How much MS SQL Sever200 will cost per a PC? (any idea even approx.)??
Thanks in advanced!
~~CS4Ever~~there's the T-SQL BACKUP DATABASE statement :
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 ] ]
]
> How much MS SQL Sever200 will cost per a PC?
Given that it's 1800 years out of date, probably pretty cheap ;-)
(joke!) - have a lookhere|||And once backed up is it possible to restore the database?
No comments:
Post a Comment