One of my blog reader encountered below error, I have given him the below solution which has resolved this issue.
Error: (SQL Server 6.5)
2009/07/15 19:42:26.89 spid1 Activating disk ‘ITEMPRICE_DATA1’
2009/07/15 19:42:26.89 kernel udopen: operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device F:\DATA\ITEMPRICE_DATA1.DAT
2009/07/15 19:42:26.89 kernel udactivate (primary): failed to open device F:\DATA\ITEMPRICE_DATA1.DAT for vdn 42
2009/07/15 19:42:26.89 spid1 Activating disk ‘ITEMPRICE_DATA2’
2009/07/15 19:42:26.89 kernel udopen: operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device F:\DATA\ITEMPRICE_DATA2.DAT
2009/07/15 19:42:26.89 kernel udactivate (primary): failed to open device F:\DATA\ITEMPRICE_DATA2.DAT for vdn 43
Solution
1) Rebuilding System Databases by running setup again from the SQL Server Install CD and do a rebuild master.
2) If it’s a 6.5 box, you can go to the console and view the sa password in the registry. run regedit from the console:
HKEY_CURRENT_USER
Software
Microsoft
MSSQLServer
SQLEW
Registered
SQL 6.5
ServerName
3) Check for the directory whether F:\ has Data directory or not
4) Check if the drive was corrupted
4) Check the SQL Server Service running on which account, check the permission of that account
5) http://support.microsoft.com/kb/180500
6) http://support.microsoft.com/kb/236989
7) Go through BOL on SQL Server 6.5 startup parameters
8) Try to login using command prompt and execute Sp_Resetstatus, DBCC CheckDB etc
sqlservr -c -f -T3608 -T4022
9) Check all the databases status from sysdatabases
