用bcp命令把表生成文件(.txt)
反之一样
反之一样
解决方案 »
- 请大家帮我看看这种复杂的情况怎么去写sql语句
- SQL2005 SP3安装失败,大虾请进!!!
- ms sql 行转列 统计
- 求解决思路
- 求两段时间之间的月数?
- 菜鸟,求有关T-SQL字符串函数语句!
- 帮忙找一下 sql server2000 我要下
- 如何查找数据库中两个字段的内容都相同的项!
- 如何建立与SQL Server的数据源的连接???
- 急!为什么SQL SERVER数据库刚用半年就越来越慢?
- 请问vc下如何调用SQL SERVER的存储过程?
- delphi调用sql server,在adodataset的commandtext中写下如下代码:执行后报"ODBC SQL SERVR没有执行可选特性"
详细查看books on line
Dim RestoreObj As New SQLDMO.Restore
serverObj.Connect "aaa", UserID, Password
RestoreObj.Database = "bbb"
RestoreObj.Files = BackUpFile
RestoreObj.Action = SQLDMORestore_Database
RestoreObj.SQLRestore serverObj
bbb是数据库名称
Syntax
Backing up an entire database: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 ] ]
]Syntax
Restore an entire database:RESTORE DATABASE { database_name | @database_name_var }
[ FROM < backup_device > [ ,...n ] ]
[ WITH
[ RESTRICTED_USER ]
[ [ , ] FILE = { file_number | @file_number } ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]
[ [ , ] MOVE 'logical_file_name' TO 'operating_system_file_name' ]
[ ,...n ]
[ [ , ] KEEP_REPLICATION ]
[ [ , ] { NORECOVERY | RECOVERY | STANDBY = undo_file_name } ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] REPLACE ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
]具体含义,请察看查询分析器的T-SQL 帮助
Dim transql As String
On Error Resume Next
transql = "use master " & _
"DISK INIT " & _
"Name='Device_1'," & _
"Physname=' " & Trim(Text1.Text) & " '," & _
"vdevno=10," & _
"size=102400"
cn.Execute (transql)
On Error GoTo err2
sql = "BACKUP DATABASE yourdatabase TO disk='" & Trim(Text1.Text) & "\yourdatabase_" & Format(CStr(Now), "yyyy-mm-dd-hh-mm-ss") & "' with noinit"cn.Execute (sql)其中 cn 是ado连接
Text1.Text 是你要备份的路径恢复-------------------
cnn.ConnectionTimeout = 10
connstr = "Driver={SQL Server};Server=(local);UID=sa;PWD=;DATABASE=master"
cnn.Open connstr
DoEvents
Label3.Caption = "正在恢复数据库......"
Me.Refresh
sql = "RESTORE DATABASE fcda FROM disk='" & Trim(Text1.Text) & "' "
cnn.Execute (sql)我在sql2000 和win 通过