Sorry if this is not the right forum.
I am a complete newbie to Teradata. I installed Teradata Express on Windows 7 and I was wondering what filetypes Teradata Express databases are stored in? For example, SQL Server Express uses MDF and LDF files. What does Teradata Express use? Thanks.
Teradata is not a file based database engine. It will not create any such files specific to any database. TD have its own internal file system that supports shared nothing architecture. Please refer to Teradata fundamentals to understand more on the architecture. FYI.
Teradata Express for Windows is a special case. It has a modified file system that is built inside regular Windows files. I don't know what the files are named, but there will be exactly two of them--one for each AMP. All other Teradata systems use raw partitions or dedicated devices.
Turns out that they are stored in files with names like:
Amp?-Pdisk0 (no extension), and
I don't know if there is any system to it.