|
|
Posted by Erland Sommarskog on 10/19/05 01:16
Christian R (Christian.Rosseel@pandora.be) writes:
> I'm sorry, but Microsoft SQL Server 2000 is pretty new for me, and I
> really do not now what kind of format the database (.dat) is.
As David said, it could be anything. All I know is that you said:
The '.dat' file contain a fully database, with many different tables.
Each of them contain many different rows.
Do you know that this is actually SQL 2000? .dat is not normal file
extension in SQL 2000. This could be Ingress, Informix, Oracle or
whatever. (Well, maybe none of them would ever use .dat, but since I
don't know them, I will have to assume that they may.)
There is one SQL Server context where .dat appears though, and that is
an SQL 6.5 device file. If this really is such a file, you cannot
access it with SQL 2000. SQL 6.5 had a completely architecture, and
the only program that can read SQL 6.5 device files is SQL 6.5. Which,
thankfully, is available on MSDN Subscriber Downloads.
> I have trying to open it with a text editor, because I don't have a hex
> editor and the only thing is have seen is computer language. I also
> tried a 'RESTORE FILELISTONLY' from the command prompt, but that didn't
> work. It my be look a little stupid that I have tried it from the
> command prompt, but I don't now what else it means. I suppose I have to
> search it in the server itself, but my version is in Dutch. Perhaps you
> can tell me where I can find that option in the menu of the Enterprise
> Manager?
Use Query Analyzer to run T-SQL commands.
> What I not have tried is 'sp_attach_single_file_db'. Can you explain me a
> little more about that possibility, perhaps that work?
exec sp_attach_single_file_db 'yourdb', 'C:\temp\yourfile.dat'
Note that the file path relates to the server, not your workstation
(unelss you run SQL Server locally).
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|