数据库备份问题 需要将一台数据库服务器上的数据时时备份到另一台pc主机,数据库为SQL Server2000,高手请帮忙啊,谢谢先。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 backup database备份你的数据库 SQL2000好象不能直接备份到远程机,但是你可以在本地备份好之后COPY到远程机去啊? backup database sys to disk='c:\目录\a.bak' with init 差异: backup database sys to disk='c:\目录\a.bak' WITH DIFFERENTIAL 没实现过可以这样试一试:backup database master to disk='网络路径' with init然后把网络路径的文件夹共享 完全备份var s_backuppath:string; s_server:string; s_database:string; s_backupfilename:string;begin StatusBar1.Panels[2].text:=''; StatusBar1.Panels[2].text:='请等候,数据库备份中......'; s_backuppath:=edit1.Text; s_server:=edit2.Text; s_database:=edit3.Text; s_backupfilename:=s_backuppath+datetostr(now); Adocommand1.ConnectionString :='Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog='+s_database+';Data Source='+s_server; ADOCommand1.CommandText := 'use Master'; ADOCommand1.Execute; adocommand1.CommandText := 'execute sp_helpdevice'; adocommand1.Execute; adocommand1.CommandText := 'backup database ' + s_database + ' to disk=''' +s_backupfilename + ''' with init'; //adocommand1.CommandText := 'backup database ' + 'BanShanDB' + ' to disk=''' +'c:\data.bak' + ''' with init'; adocommand1.Execute; adocommand1.CommandText := 'Use ' + s_database; adocommand1.Execute; StatusBar1.Panels[2].text:=''; StatusBar1.Panels[2].text:='数据库备份完成!'; // application.MessageBox('已经成功备份数据库','数据库备份',MB_OK + MB_ICONINFORMATION);end;差异 与完全差不多: backup database sys to disk='c:\目录\a.bak' WITH DIFFERENTIAL 请问这样的操作对sql server2000的版本有要求吗 现在还没条件装服务器版的sql server2000不能测试了散分先 <--------------高手看过来! 能不能搞定这个?http://community.csdn.net/Expert/topic/3472/3472337.xml?temp=.2961847 文件删除函数? 内存流数据转化成jpeg格式后,如何将其保存为AVI视频格式 怪怪怪,qq的问题 鼠标指向一个控件时,右下角显示一个说明框这个功能怎么实现?? 请进来看看,从BCB翻译过来的代码,为什么就不能运行?在线等 图片的剪切问题 关于字符串的两个问题 一个多层应用系统的连接问题,怪怪的,很有趣! 湖大的 DELPHI Fans Come in!!!!!!!!!! 客户程序在服务器上能正常执行,在客户端运行时报告服务器不能运行? 这就是传说中的倒分贴??? 怎么把inputquery里输入的字显示为密码的样子?
差异:
backup database sys to disk='c:\目录\a.bak' WITH DIFFERENTIAL
backup database master to disk='网络路径' with init
然后把网络路径的文件夹共享
var
s_backuppath:string;
s_server:string;
s_database:string;
s_backupfilename:string;
begin
StatusBar1.Panels[2].text:='';
StatusBar1.Panels[2].text:='请等候,数据库备份中......';
s_backuppath:=edit1.Text;
s_server:=edit2.Text;
s_database:=edit3.Text;
s_backupfilename:=s_backuppath+datetostr(now);
Adocommand1.ConnectionString :='Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog='+s_database+';Data Source='+s_server;
ADOCommand1.CommandText := 'use Master';
ADOCommand1.Execute;
adocommand1.CommandText := 'execute sp_helpdevice';
adocommand1.Execute;
adocommand1.CommandText := 'backup database ' + s_database + ' to disk=''' +s_backupfilename + ''' with init';
//adocommand1.CommandText := 'backup database ' + 'BanShanDB' + ' to disk=''' +'c:\data.bak' + ''' with init';
adocommand1.Execute;
adocommand1.CommandText := 'Use ' + s_database;
adocommand1.Execute;
StatusBar1.Panels[2].text:='';
StatusBar1.Panels[2].text:='数据库备份完成!';
// application.MessageBox('已经成功备份数据库','数据库备份',MB_OK + MB_ICONINFORMATION);
end;差异 与完全差不多:
backup database sys to disk='c:\目录\a.bak' WITH DIFFERENTIAL
不能测试了散分先
http://community.csdn.net/Expert/topic/3472/3472337.xml?temp=.2961847