一、错误
1. 一开始用sybase示例库pubs2进行备份,报如下错误
Syslogs does not exist in its own segment in database 'test' with segmap '7'with logical start page number of '0'. You cannot use DUMP TRANSACTION in this case, use DUMP DATABASE instead.
删除日志段的设备(master.dat)并重新分配日志设备后后执行备份,报如下错误
2.DUMP TRANSACTION for database 'DBname' failed: log page (1030) is on a data-only segment. This is probably due to an incomplete move of the log to a device separate from the data. Complete the log migration or contact the System Administrator.
××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××
to resolve the error:
-
Run dbcc checktable(syslogs) to determine which page is currently in use.
-
Execute enough transactions to fill the extent currentlyin use. The fo