Hi there
I'm hoping somebody here can help with this problem. In the Application Event Viewer we're seeing a problem. The error message is below
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 17207, udopen: Operating system error 32(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf
Its promptly followed by this error
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 17204, FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf for virtual device number (VDN) 1
The machine is running MSDE as its SQL Server and has two DBs
DB on D: which is 148,628k
DB on C: which is 237,568k
I'm pretty stuck on this one, so if anybody knows what's causing this problem, and more importantly how I can go about fixing it, it'd be most appreciated - I'm no SQL Guru and haven't been able to find a huge amount on knowledgebase searches or google searches
Thanks in anticipation
Steve S
stevesdmREMOVETHIS@.hotmail.comI dont know if this will help anyone, but the sql log shows this
2004-05-26 12:33:58.27 spid7 Starting up database 'Genifax'
2004-05-26 12:34:56.71 spid52 Starting up database 'Genifax'
2004-05-26 12:34:58.60 spid7 Starting up database 'Genifax'
2004-05-26 12:35:06.49 spid52 Starting up database 'Genifax'
2004-05-26 12:35:28.27 spid7 Starting up database 'Genifax'
2004-05-26 12:35:53.69 spid52 Starting up database 'Genifax'
2004-05-26 12:35:58.68 spid7 Starting up database 'Genifax'
2004-05-26 12:36:00.65 spid52 Starting up database 'Genifax'
2004-05-26 12:36:28.43 spid7 Starting up database 'Genifax'
2004-05-26 12:36:53.69 spid52 Starting up database 'Genifax'
2004-05-26 12:37:52.49 spid52 Starting up database 'Genifax'
2004-05-26 12:38:01.08 spid52 Starting up database 'Genifax'
2004-05-26 12:38:53.72 spid52 Starting up database 'Genifax'
2004-05-26 12:38:53.72 spid52 udopen: Operating system error 32(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf
2004-05-26 12:38:53.74 spid52 FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf for virtual device number (VDN) 1
2004-05-26 13:23:09.55 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager
The bottom line is where MSDE is restarted (which cures the problem for a day or two upon which MSDE causes problems again)
Like I said in my last message, any help is very very much appreciated
Thanks
Stev
Showing posts with label udopen. Show all posts
Showing posts with label udopen. Show all posts
Subscribe to:
Posts (Atom)