前段时间想着要发展其他数据库上面的AUL恢复软件, 前段时间联系了一个Sybase上的高手, 开发了AUL for Sybase, 现在提供的是测试版本, 我们也正在努力地完善它.
用Sybase的数据库朋友可以试试.
Posted on Apr 16, 2008 1:28 PM | Permalink | AUL/MyDUL
你應也可做一個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
Posted by carny | Apr 16, 2008 5:58 PM
好的，会做的。虽不一定是我自已做的，但肯定会有AUL for SQLServer。
Posted by anysql | Apr 16, 2008 7:01 PM
关注。。。
Posted by Gabri | Apr 19, 2008 2:54 PM
是这个牛人吗？
http://hobbylu.blogcn.com/diary,9141872.shtml
你们都是牛人，我只能关注＋崇拜了。
Posted by 方风 | Apr 23, 2008 10:54 AM
姓名: (必须)
邮件: (必须, 但不显示)
主页:
验证码(必需输入): 记住我?
留言内容: (可以使用部份HTML标记)
« Previous | Main | Next »
留言 (4)
你應也可做一個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
Posted by carny | Apr 16, 2008 5:58 PM
好的，会做的。虽不一定是我自已做的，但肯定会有AUL for SQLServer。
Posted by anysql | Apr 16, 2008 7:01 PM
关注。。。
Posted by Gabri | Apr 19, 2008 2:54 PM
是这个牛人吗？
http://hobbylu.blogcn.com/diary,9141872.shtml
你们都是牛人，我只能关注＋崇拜了。
Posted by 方风 | Apr 23, 2008 10:54 AM