- 論壇徽章:
- 0
|
公司遷移數(shù)據(jù)庫,在源上做dump,在目標(biāo)上做load.
在load時遇到如下錯誤
Backup Server session id is: 17. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Msg 3240, Level 18, State 2:
Server 's1', Line 1:
Unable to obtain the SQL Server's current working directory. The SQL Server must have search permission on its current working directory and the name must be shorter than 255 bytes.
Msg 3240, Level 18, State 1:
Server 's1', Line 1:
Unable to obtain the SQL Server's current working directory. The SQL Server must have search permission on its current working directory and the name must be shorter than 255 bytes.
Msg 103, Level 15, State 13:
Server 's1', Line 1:
The parameter that starts with '' is too long. Maximum length is 255.
日志中錯誤如下:
06:00000:00553:2013/07/09 03:17:29.58 kernel Could not get the server current working directory. Possible NFS problem. Future dump/load operations may fail.
06:00000:00553:2013/07/09 03:17:29.58 kernel getwd: can't open ..
06:00000:00553:2013/07/09 03:17:29.59 kernel Could not get the server current working directory. Possible NFS problem. Future dump/load operations may fail.
06:00000:00553:2013/07/09 03:17:29.59 kernel getwd: can't open ..
查閱官方說明,Msg 3240 用戶權(quán)限有問題.
檢查相關(guān)權(quán)限屬主,貌似沒問題.
最后umount 文件系統(tǒng)后,發(fā)現(xiàn)掛載點 /sybase 目錄的屬主是root,改成sybase:sybase后重新mount,并再次賦為sybase:sybase 問題解決. |
|