大侠:如何备份、恢复数据库啊??MDI窗口如何实现横向、纵向、层叠排列??
解决方案 »
- VCL源码里,某些函数上面有这么一段是什么意思?
- 求 获取稀疏文件实际占用空间的方法
- $IFDEF DEBUGMSG是什么意思?
- 怎么判断treeview选中的某节点下面有子节点和孙节点?
- 如何设置richedit的滚动条位置并让它滚动到指定位置
- 请问高手如何让dbgrid实现输入查询条件的功能:第一行显示字段名,第二行空白让用户输入条件,第三行类似COMBOBOX显示> < =等条件
- CSDN会员每日邮递表是什么东西?
- 如何使桌面变成一个画布对象??多指教!
- 答者有分
- 要用delphi做个上位机,求助
- 谁能帮我解决一下delphi对sql2000数据库数据备份和数据还原的问题。
- 数据库远程备份到本地
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
用TActionList现实,不用写代码...
Tile;TileMode := tbVertical; //横向
Tile;
//mnuCascade.Click
procedure TfrmComMain.mnuCascadeClick(Sender: TObject);
var
i:integer;
begin
for i := MDIChildCount - 1 downto 0 do
MDIChildren[i].WindowState := wsNormal;
for i := MDIChildCount - 1 downto 0 do
MDIChildren[i].WindowState := wsNormal;
Cascade;
end;//mnuHorizontally.Click
procedure TfrmComMain.mnuHorizontallyClick(Sender: TObject);
var
i:integer;
begin
for i := MDIChildCount - 1 downto 0 do
MDIChildren[i].WindowState := wsNormal;
for i := MDIChildCount - 1 downto 0 do
MDIChildren[i].WindowState := wsNormal;
Tile;
end;//mnuMinAll.Click
procedure TfrmComMain.mnuMinAllClick(Sender: TObject);
var
i:integer;
begin
for i := MDIChildCount - 1 downto 0 do
MDIChildren[i].WindowState := wsMinimized;
ArrangeIcons;
end;//mnuCloseAll.Click
procedure TfrmComMain.mnuCloseAllClick(Sender: TObject);
var
i:integer;
begin
for i := MDIChildCount - 1 downto 0 do
MDIChildren[i].Close;
end;
参数:databasename数据库名,filename数据库备份文件名
////////////////////////////////////////////////////////
function sqlrestore(databasename,filename:string):boolean;
begin
if (databasename<>'') and (filename<>'') then
begin
try
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.CommandTimeout:=120;
adoquery1.SQL.Add('use master');
adoquery1.SQL.Add('alter database '+databasename+' set offline WITH ROLLBACK IMMEDIATE');
adoquery1.SQL.Add('restore database '+databasename+' from disk='''+filename+''''+' with REPLACE ');
adoquery1.SQL.Add('alter database '+databasename+' set online with rollback immediate');
adoquery1.ExecSQL;
result:=true;
except
result:=false;
exit;
end;
end;
end;////////////////////////////////////////////////////////
功能:SQL数据库备份
参数:databasename数据库名,savepath数据库备份文件名
////////////////////////////////////////////////////////
function TForm7.sqlback(databasename,savepath:string):boolean;
begin
if (databasename<>'')and (savepath<>'') then
begin
try
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('backup database '+databasename+ ' to disk='''+savepath+'''');
adoquery1.ExecSQL;
result:=true;
except
result:=false;
exit;
end;
end;
end;
[ 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 ] ]
]