当前位置: 代码迷 >> Sybase >> sybase数据库恢复后看不到一张表,恢复过程并无出错!解决方案
  详细解决方案

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

热度:7942   发布时间:2013-02-26 00:00:00.0
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.

------解决方案--------------------------------------------------------
  相关解决方案