首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > Sybase >

sybase数据库恢复后看不到一张表,恢复过程并无出错!解决方案

2012-03-02 
sybase数据库恢复后看不到一张表,恢复过程并无出错!sybase数据库恢复后看不到一张表,恢复过程并无出错!数

sybase数据库恢复后看不到一张表,恢复过程并无出错!
sybase数据库恢复后看不到一张表,恢复过程并无出错!

数据是从11.9.2中备份出来的,恢复到12.5.2,恢复信息如下,请高手赐教!

----------------------  
--   fzjg   Restore   Messages
----------------------  
Backup   Server   session   id   is:     20.     Use   this   value   when   executing   the   'sp_volchanged '   system   stored   procedure   after   fulfilling   any   volume   change   request   from   the   Backup   Server.
Backup   Server:   6.28.1.1:   Dumpfile   name   'fzjg072430D18C       '   section   number   1   mounted   on   disk   file   'd:\fzjg.dmp '
Backup   Server:   4.58.1.1:   Database   fzjg:   50182   kilobytes   LOADed.
Backup   Server:   4.58.1.1:   Database   fzjg:   93194   kilobytes   LOADed.
Backup   Server:   4.58.1.1:   Database   fzjg:   136714   kilobytes   LOADed.
Backup   Server:   4.58.1.1:   Database   fzjg:   179726   kilobytes   LOADed.
Backup   Server:   4.58.1.1:   Database   fzjg:   223246   kilobytes   LOADed.
Backup   Server:   4.58.1.1:   Database   fzjg:   266258   kilobytes   LOADed.
Backup   Server:   4.58.1.1:   Database   fzjg:   309778   kilobytes   LOADed.
Backup   Server:   4.58.1.1:   Database   fzjg:   352790   kilobytes   LOADed.
Backup   Server:   4.58.1.1:   Database   fzjg:   396310   kilobytes   LOADed.
Backup   Server:   4.58.1.1:   Database   fzjg:   439322   kilobytes   LOADed.
Backup   Server:   4.58.1.1:   Database   fzjg:   482842   kilobytes   LOADed.
Backup   Server:   4.58.1.1:   Database   fzjg:   512028   kilobytes   LOADed.
Backup   Server:   4.58.1.1:   Database   fzjg:   512036   kilobytes   LOADed.
Backup   Server:   3.42.1.1:   LOAD   is   complete   (database   fzjg).
All   dumped   pages   have   been   loaded.     SQL   Server   is   now   clearing   pages   above   page   256000,   which   were   not   present   in   the   database   just   loaded.
SQL   Server   has   finished   clearing   database   pages.
Started   estimating   recovery   log   boundaries   for   database   'fzjg '.
Completed   estimating   recovery   log   boundaries   for   database   'fzjg '.
Started   ANALYSIS   pass   for   database   'fzjg '.
Completed   ANALYSIS   pass   for   database   'fzjg '.
Started   REDO   pass   for   database   'fzjg '.   The   total   number   of   log   records   to   process   is   1.
Completed   REDO   pass   for   database   'fzjg '.
Use   the   ONLINE   DATABASE   command   to   bring   this   database   online;   SQL   Server   will   not   bring   it   online   automatically.

------解决方案--------------------


select name from sysobjects where type= 'U '
[解决办法]
看一下这个数据库user的信息,导入的数据很可能出现在数据库中只有user信息而没有login 信息的bug,这种情况你需要把当前出问题的user都drop掉,然后重新加入正确的user和login信息,之后重新连接数据库试试看接过

热点排行