如何写一个DELPHI备份SQL数据库程式? 我用的DELPHI7.0,SQL是企业版,我想在DELPHI中写一个备份数据库的操作界面,却不知怎样下手,请高手大虾指点,再好是详细代码?我的SQL数据库文件在在d:\Program files\MicrosoftSQL Server\MSSQL\Data中 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 参考这个http://www.2ccc.com/article.asp?articleid=1360 打开事件跟踪器,跟踪事件然后在企业管理器中备份一个数据库这时可以在事件跟踪器中找到备份数据库的SQL语句把那一句粘过去,把相关参数改了,或设为变量即可 http://www.2ccc.com/article.asp?articleid=1149 http://www.2ccc.com/article.asp?articleid=1157 備份整個資料庫:RESTORE DATABASE { database_name | @database_name_var } [ FROM < backup_device > [ ,...n ] ] [ WITH [BLOCKSIZE = { blocksize | @blocksize_variable }] [ [ , ] MEDIADESCRIPTION = { 'text' | @text_variable } ] [ [ , ] DIFFERENTIAL ] [ [ , ] EXPIREDATE = { date | @date_var } | RETAINDAYS = { days | @days_var } ] [ [ , ] PASSWORD = { password | @password_variable } ] [ [ , ] FORMAT | NOFORMAT ] [ [ , ] { INIT | NOINIT } ] [ [ , ] DESCRIPTION = { '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 ] ] ]備份指定的檔案或檔案群組:BACKUP DATABASE { database_name | @database_name_var } < file_or_filegroup > [ ,...n ] TO < backup_device > [ ,...n ] [ WITH [ BLOCKSIZE = { blocksize | @blocksize_variable } ] [ [ , ] MEDIADESCRIPTION = { 'text' | @text_variable } ] [ [ , ] EXPIREDATE = { date | @date_var } | RETAINDAYS = { days | @days_var } ] [ [ , ] PASSWORD = { password | @password_variable } ] [ [ , ] FORMAT | NOFORMAT ] [ [ , ] { INIT | NOINIT } ] [ [ , ] DESCRIPTION = { '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 ] ] ] 在DELPHI 汉字截取了,怎么弄好? 求解!playsound函数问题 sql语句,提示语法错误(操作符丢失)在查询表达式'*from rc1 where 元器件ID='1''中 多个ie进程时弹出的ie窗口如何使其在最前面??急!! 求助!!!!! ◆◆谁能帮我解决这个问题,分不够还可以加◆◆ InterBase 6。0如何得到一个结果集的第一条记录呢。 请教前辈或做财务的高手,开发一个财务软件大约要多长时间?顶者有份! 关于图标问题? 关于菜单的两个问题 关于DBGRID的显示问题 关于Delphi与地理信息系统~~请高手门赐教~~~~~~
http://www.2ccc.com/article.asp?articleid=1360
然后在企业管理器中备份一个数据库
这时可以在事件跟踪器中找到备份数据库的SQL语句
把那一句粘过去,把相关参数改了,或设为变量即可
[ FROM < backup_device > [ ,...n ] ]
[ WITH
[BLOCKSIZE = { blocksize | @blocksize_variable }]
[ [ , ] MEDIADESCRIPTION = { 'text' | @text_variable } ]
[ [ , ] DIFFERENTIAL ]
[ [ , ] EXPIREDATE = { date | @date_var }
| RETAINDAYS = { days | @days_var } ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] FORMAT | NOFORMAT ]
[ [ , ] { INIT | NOINIT } ]
[ [ , ] DESCRIPTION = { '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 ] ]
]備份指定的檔案或檔案群組:BACKUP DATABASE { database_name | @database_name_var }
< file_or_filegroup > [ ,...n ]
TO < backup_device > [ ,...n ]
[ WITH
[ BLOCKSIZE = { blocksize | @blocksize_variable } ]
[ [ , ] MEDIADESCRIPTION = { 'text' | @text_variable } ]
[ [ , ] EXPIREDATE = { date | @date_var }
| RETAINDAYS = { days | @days_var } ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] FORMAT | NOFORMAT ]
[ [ , ] { INIT | NOINIT } ]
[ [ , ] DESCRIPTION = { '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 ] ]
]