dump database命令请教
时间:2011-04-11
来源:互联网
资料上说备份数据库的语法为: dump database database_name to dump_device
例如:dump database mydb to mydb-bk
我试图通过如下命令备份master数据库提示错误
use master
dump database master to 'd:\mydata\master20081120.dat'
go
------------------------ Execute ------------------------
WARNING: In order to LOAD the master database, the SQL Server must run in single-user mode. If the master database dump uses multiple volumes, you must execute sp_volchanged on another SQL Server at LOAD time in order to signal volume changes.
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.
----------------- Done ( 2 errors ) ------------------
通过如下命令备份model数据库提示错误
use model
dump database model to 'd:\mydata\model20081120.dat'
go
------------------------ Execute ------------------------
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.
----------------- Done ( 2 errors ) ------------------
出什么错是知道了,但不知道怎么处理!
1:如何让sql server运行在单用户模式?
2:dump_device是个什么样的概念,简单说是一个路径(象我写的那样)还是需要预先定义?
3: Can't open a connection to site 'SYB_BACKUP'. 一般是什么原因,我在sql server根目录下的log文件中没有发现有用的信息啊?
谢谢(初次弄这个,烦大家多多帮助)!
例如:dump database mydb to mydb-bk
我试图通过如下命令备份master数据库提示错误
use master
dump database master to 'd:\mydata\master20081120.dat'
go
------------------------ Execute ------------------------
WARNING: In order to LOAD the master database, the SQL Server must run in single-user mode. If the master database dump uses multiple volumes, you must execute sp_volchanged on another SQL Server at LOAD time in order to signal volume changes.
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.
----------------- Done ( 2 errors ) ------------------
通过如下命令备份model数据库提示错误
use model
dump database model to 'd:\mydata\model20081120.dat'
go
------------------------ Execute ------------------------
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot directory.
----------------- Done ( 2 errors ) ------------------
出什么错是知道了,但不知道怎么处理!
1:如何让sql server运行在单用户模式?
2:dump_device是个什么样的概念,简单说是一个路径(象我写的那样)还是需要预先定义?
3: Can't open a connection to site 'SYB_BACKUP'. 一般是什么原因,我在sql server根目录下的log文件中没有发现有用的信息啊?
谢谢(初次弄这个,烦大家多多帮助)!
作者: 慵懒的公交车 发布时间: 2011-04-11
备份服务没有起
作者: Eisen 发布时间: 2011-04-11
确认一下远程服务器中有没有这样一个syb_backup的服务,印象中12.5.X一个版本中要手动去配
作者: qjhadm 发布时间: 2011-04-11
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28