数据库备份:
string sql;
string file;
file = "d:\backup\database.bak"sql = 'EXEC'+'('+"'USE master'"+')'
EXECUTE IMMEDIATE :sql ;
SQLCA.AutoCommit = TRUE
sql = "EXEC sp_addumpdevice 'disk'"+" , 'databasename' , "+" '"+file+"'"
EXECUTE IMMEDIATE : sql ;
sql ='BACKUP DATABASE databasename to databasename'
EXECUTE IMMEDIATE : sql ;
sql = "exec sp_dropdevice 'databasename'"
EXECUTE IMMEDIATE : sql ;
SQLCA.AutoCommit = false
sql = 'EXEC'+'('+"'USE databasename'"+')'
EXECUTE IMMEDIATE :sql ;
数据库恢复:
file = "d:\backup\database.bak"
sql = of_connectdb_master()
SQLCA.AutoCommit = TRUE
sql = "EXEC sp_addumpdevice 'disk'"+" , 'databasename' , "+" '"+file+"'"
EXECUTE IMMEDIATE : sql ;
sql = "EXEC sp_dboption @dbname = 'databasename', @optname = 'single user', @optvalue = true"
EXECUTE IMMEDIATE : sql ;
sql ='RESTORE DATABASE databasename FROM databasename'
EXECUTE IMMEDIATE : sql ;
sql = "EXEC sp_dboption @dbname = 'databasename', @optname = 'single user', @optvalue = false"
EXECUTE IMMEDIATE : sql ;
sql = "exec sp_dropdevice 'databasename'"
EXECUTE IMMEDIATE : sql ;
SQLCA.AutoCommit = false
Disconnect Using sqlca;
string sql;
string file;
file = "d:\backup\database.bak"sql = 'EXEC'+'('+"'USE master'"+')'
EXECUTE IMMEDIATE :sql ;
SQLCA.AutoCommit = TRUE
sql = "EXEC sp_addumpdevice 'disk'"+" , 'databasename' , "+" '"+file+"'"
EXECUTE IMMEDIATE : sql ;
sql ='BACKUP DATABASE databasename to databasename'
EXECUTE IMMEDIATE : sql ;
sql = "exec sp_dropdevice 'databasename'"
EXECUTE IMMEDIATE : sql ;
SQLCA.AutoCommit = false
sql = 'EXEC'+'('+"'USE databasename'"+')'
EXECUTE IMMEDIATE :sql ;
数据库恢复:
file = "d:\backup\database.bak"
sql = of_connectdb_master()
SQLCA.AutoCommit = TRUE
sql = "EXEC sp_addumpdevice 'disk'"+" , 'databasename' , "+" '"+file+"'"
EXECUTE IMMEDIATE : sql ;
sql = "EXEC sp_dboption @dbname = 'databasename', @optname = 'single user', @optvalue = true"
EXECUTE IMMEDIATE : sql ;
sql ='RESTORE DATABASE databasename FROM databasename'
EXECUTE IMMEDIATE : sql ;
sql = "EXEC sp_dboption @dbname = 'databasename', @optname = 'single user', @optvalue = false"
EXECUTE IMMEDIATE : sql ;
sql = "exec sp_dropdevice 'databasename'"
EXECUTE IMMEDIATE : sql ;
SQLCA.AutoCommit = false
Disconnect Using sqlca;
解决方案 »
- 一个不简单的查询问题
- 求sql代码 20090801
- 求一条sql语句
- 我取得了一个uniqueidentifier值,用SQL语句取得的,取得后是一个字符串,我想把它又写入另一个表,但是发行无法转换字符串到这个类型
- 哪有集成sp4的mssqlserver2000的安装包下载呀,每次重装sql2000后,都果打补丁,太麻烦了。
- sql语句请高手帮忙!
- 请问有MS SQL Server 2005 Standard Edition或者Developer Edition的下载地址??
- 急:数据库中的表 XXX 是存在的,为什么总提示 “对象名 XXX 无效”!
- 请教这种效果的SQL应该怎么写啊?
- 请问SQL中有没有语句可以设置返回的记录数?急!!!
- 如何把空值赋给变量?@value=NULL?,这有个问题,存储过程
- 在线等待!!急急急!!关于时间函数....
backup database name to disk='路径+文件名' with init
//数据库中某个数据表的备份语句
ADOQuery1.SQL.Add('EXEC master..xp_cmdshell'+'''bcp '+DataBaseName+'.dbo.'+TableName+' out '+路径+文件名+' -c -q -S"'+servername+'" -U"'+username+'" -P"'+password+'"''')
//整个数据库恢复语句
ADOQuery1.SQL.Add('Use master EXEC sp_dboption '''+DataBaseName+''','''+'single user'+''','''+'True''');
ADOQuery1.SQL.Add('Restore database '+DataBaseName+' from disk='''+路径+文件名+'''');
ADOQuery1.SQL.Add('EXEC sp_dboption '''+DataBaseName+''','''+'single user'+''','''+'False''');
//数据库中某个数据表的恢复语句
ADOQuery1.SQL.Add('EXEC master..xp_cmdshell'+'''bcp '+DataBaseName+'.dbo.'+TableName+' in '+路径+文件名+' -c -q -S"'+servername+'" -U"'+username+'" -P"'+password+'"''');