|
1、还原数据库源不能有中文路径
2、JDBC连接非默认实例jdbc:jtds:${jdbc.db}://${jdbc.ip}:${jdbc.port};instance=IMS ? ? ? (?net.sourceforge.jtds.jdbc.Driver)
创建备份设备
EXEC sp_addumpdevice 'disk','om_backup','D:DataBaseBackupom.bak'
EXEC sp_addumpdevice 'disk','ims_backup','D:DataBaseBackupims.bak'
EXEC sp_addumpdevice 'disk','imsparam_backup','D:DataBaseBackupimsparam.bak'
EXEC sp_addumpdevice 'disk','imsstore_backup','D:DataBaseBackupimsstore.bak'
EXEC sp_addumpdevice 'disk','wf_backup','D:DataBaseBackupwf.bak'
备份数据库
BACKUP DATABASE om TO om_backup
BACKUP DATABASE ims TO ims_backup
BACKUP DATABASE imsparam TO imsparam_backup
BACKUP DATABASE imsstore TO imsstore_backup
BACKUP DATABASE wf TO wf_backup
还原数据库
RESTORE DATABASE om FROM om_backup
RESTORE DATABASE ims FROM ims_backup
RESTORE DATABASE imsparam FROM imsparam_backup
RESTORE DATABASE imsstore FROM imsstore_backup
RESTORE DATABASE wf FROM wf_backup
3、删除重复数据?delete ? YourTable ??where ? [id] ? not ? in ? (?select ? max([id]) ? from ? YourTable ??group ? by ? (name ? + ? value))?
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
