zm852 发表于 2006-11-23 11:44:36

新手LOAD数据库故障inASE 15

<span style="FONT-SIZE: 13px;">在建库FOXHIS(2G)后,恢复数据时报空间小了,NEED 3000MB。。但是data.dat文件才280M,这是为什么哦?不得已,扩库到4G后,再load database 结果又报这个错,大家看看,帮忙一起解决这个问题。。谢<br/>___________________________________________________________<br/>Backup Server: 3.42.1.1: LOAD is complete (database foxhis).<br/>Caution:&nbsp;&nbsp;You have set up this database to include space on disk 58 for both<br/>data and the transaction log.&nbsp;&nbsp;This can make recovery impossible if that disk<br/>fails.<br/>All dumped pages have been loaded. ASE is now clearing pages above page 1536000,<br/>which were not present in the database just loaded.<br/>ASE has finished clearing database pages.<br/>Msg 3484, Level 16, State 1:<br/>Server 'SYBASE', Line 1:<br/>Recovery encountered an error in acquiring locks for reinstantiated<br/>transactions. Please consult the Adaptive Server errorlog for further<br/>information as to the cause.<br/>))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))以上是Load完成时的样子,然后我想打开数据库,结果又出现了以下的Error!!<br/>1&gt; use foxhis<br/>2&gt; go<br/>Msg 930, Level 14, State 1:<br/>Server 'SYBASE', Line 1:<br/>Database 'foxhis' cannot be opened because either an earlier system termination<br/>left LOAD DATABASE incomplete or the database is created with 'for load' option.<br/>Load the database or contact a user with System Administrator (SA) role.<br/>???<br/>不明白了。。。</span>

zm852 发表于 2006-11-23 11:46:13

<p>DATABASE For RH AS 4</p>

flybean 发表于 2006-11-24 13:43:57

增加锁数,重新LOAD.LOAD完成后online database<br/>
页: [1]
查看完整版本: 新手LOAD数据库故障inASE 15

免责声明:
本站所发布的一切破解补丁、注册机和注册信息及软件的解密分析文章仅限用于学习和研究目的;不得将上述内容用于商业或者非法用途,否则,一切后果请用户自负。本站信息来自网络,版权争议与本站无关。您必须在下载后的24个小时之内,从您的电脑中彻底删除上述内容。如果您喜欢该程序,请支持正版软件,购买注册,得到更好的正版服务。如有侵权请邮件与我们联系处理。

Mail To:Admin@SybaseBbs.com