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信息,之后重新连接数据库试试看接过