SQL Server database file extension as .dat1 instead of .mdf

[isha]

There are 5 databases in our SQL server 2000. When I rightclick a database name in the Enterprise manager, then click at the properties of a database it shows the database file name, log file name and their locations. While the database files of four databases ends with extension .mdf and log with .ldf, one database shows the database file as .dat1 and log as .log1. I am confused, why file extension .dat1 and .log1 instead of .mdf and .ldf ? Can some one throw some light on it?

 

[SQLBill]

I don't know, but as a quess...did you restore a SQL Server 6.5 or 7 database to your 2000 instance?

-SQLBill

 

[isha]

SQLBill,
This database was loaded by some other programmer previously. i think he may have restored the database from SQL Server7 or so. But I am not confirmed.

 

[SQLBill]

If it's a database restored from another version, that's probably the reason the extension is different. These were changed through the versions. For example, backing up SQL Server 2000 creates .bak files. In SQL Server 7, I believe they create .dat files.

I've never worked with 6.5 or 7, so I can't help much on this but as I said it looks like it's a previous (non SQL 2000) version database.

-SQLBill