Error Message

Jane · February 10th, 2004, 07:57 PM

i hit and error while I download from As400 db2 data into a table that i specified

Error string: I/O error 2(The system cannot find the file specified.) detected during write at offset 0x00000012080000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf'. Error source: Microsoft OLE DB Provider for S... Process Exit Code 3. The step failed.

Jeff Mason · February 11th, 2004, 08:06 AM

It looks like you have a bad installation of SQL Server. At least one of the system databases (the database used to hold temporary data while SQL Server is running queries) is missing. Did you delete it?

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

joefawcett · February 11th, 2004, 12:15 PM

Could be that although in theory you can delete tempdb at virtually anytime and it will be re-created when needed by the system.

--

Joe

Jeff Mason · February 11th, 2004, 12:35 PM

Quote:

quote:Originally posted by joefawcett
Could be that although in theory you can delete tempdb at virtually anytime and it will be re-created when needed by the system.

Are you sure? I thought tempdb was (re)created only when the server was restarted.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com