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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment