提問者
Fail to online Database

問題
-
Hi,
I am using SQL2000 Standard Edition, sometimes, i saw following error messages in the server log and the database (i.e. FAPro) will not able to start up/access, but i can access other databases on the same SQL Server instance.
2011-01-22 15:15:17.34 spid52 udopen: 發生作業系統錯誤 32(程序無法存取檔案,因為檔案正由另一個程序使用。),當建立/開啟實體裝置 e:\Program Files\Microsoft SQL Server\MSSQL\data\FAPro_Log.LDF 時。
2011-01-22 15:15:17.34 spid52 FCB::Open failed: 無法開啟裝置 e:\Program Files\Microsoft SQL Server\MSSQL\data\FAPro_Log.LDF,為虛擬裝置號碼 (VDN) 2 。
2011-01-22 15:15:17.36 spid52 Attempting to rebuild primary log file for database FAPro.
2011-01-22 15:15:17.36 spid52 FCB::CreateFile() failed with error 80 for file e:\Program Files\Microsoft SQL Server\MSSQL\data\FAPro_log.LDF.I can fix it by restarting the SQL Service Instance, but i wanna to know the root cause and solve the problem. Please help, thanks.
所有回覆
-
how do u / what do u mean by 'dump db into a file' exactly?
Confirm that...
- File permissions are set correctly.
- No other database is using the same files.
- No other database on a different SQL instance is using the same files.
-- Martin POON -- Principal Consultant @ AppsGoGo.com -- SQL Server MVP, MCTS, MCITP ~~ http://msMVPs.com/blogs/MartinPOON ~~ http://www.MartinPOON.com