用ISQL聯接時出現如下的提示:
The tansaction log in master is almost full,Your transaction is being suspended until space is made available
用ISQL聯接時出現如下的提示:
The tansaction log in master is almost full,Your transaction is being suspended until space is made available
isql無法聯接master庫
處理方法:
1、正常重新開機資料庫後,isql仍然無法聯接MASTER
2、備份master.dat
3、在啟動批檔案中加參數-T3607啟動(sybase for win32);
4、将master庫的空間加大2M (alter database master on master=2)
5、清除已送出的事務日志(dump tran dbname with truncate_only)
6、去掉-T3607,重新開機資料庫OK