AnySQL.net

AUL Sybase数据恢复工具

AUL/MyDUL » http://www.anysql.net/aulmydul/qq_by_mobile_phone.html 2008-04-16

Tags: AUL/MyDUL, Data, Recovery, Sybase

4 Responses to “AUL Sybase数据恢复工具”

1. carny Says: 2008-04-16 at 17:58

   你應也可做一個AUL FOR MS SQL Server , 因為MS SQL Server是從SYBASE舊版,改良出來的,每個page(block)和SYBASE很像, DUMP DATABLOCK(PAGE) 語法參考如下:
   create table aaa (f1 char(2));
   insert into aaa (f1) values(’cc’);
   DBCC TRACEON (3604)
   DECLARE @dbid int, @objectid int
   SELECT @dbid = DB_ID(’pubs’)
   SELECT @objectid = object_id(’aaa’)
   DBCC TAB (@dbid,@objectid)
   645577338
   645577338
   DBCC TRACEON (3604)
   DECLARE @dbid int, @objectid int
   SELECT @dbid = DB_ID(’pubs’)
   SELECT @objectid = object_id(’aaa’)
   DBCC prtipage(@dbid,@objectid,0,0)
   DBCC TRACEON (3604)
   DBCC PAGE (pubs,1,15,1)
   DBCC PAGE (pubs,1,15,2)
   DBCC TRACEON (3604)
   DBCC DES(pubs,aaa)
   DBCC IND(pubs,aaa,0)
   DBCC dbtable(pubs)
   USE pubs
   GO
   DBCC TRACEON (3604)
   GO
   DECLARE @pgid int
   SELECT @pgid FROM sysindexes WHERE id = object_id(’aaa’)
   SELECT * FROM sysindexes WHERE id = object_id(’aaa’)
   DBCC PAGE (pubs,15 , 1)
   GO

2. anysql Says: 2008-04-16 at 19:01

   好的，会做的。虽不一定是我自已做的，但肯定会有AUL for SQLServer。

3. Gabri Says: 2008-04-19 at 14:54

   关注。。。

4. 方风 Says: 2008-04-23 at 10:54

   是这个牛人吗？
   http://hobbylu.blogcn.com/diary,9141872.shtml
   你们都是牛人，我只能关注＋崇拜了。

Leave a Reply

Name (required)

Mail (will not be published) (required)

Website