|
Subject:
|
Error Message
|
|
Posted By:
|
Jane
|
Post Date:
|
2/10/2004 6:57:22 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.
|
|
Reply By:
|
Jeff Mason
|
Reply Date:
|
2/11/2004 7:06:09 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
|
|
Reply By:
|
joefawcett
|
Reply Date:
|
2/11/2004 11:15:34 AM
|
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
|
|
Reply By:
|
Jeff Mason
|
Reply Date:
|
2/11/2004 11:35:06 AM
|
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
|
