Posted by Dan Guzman on 10/18/05 16:52

You need to know how the '.dat' file was created in order to import it. Use
RESTORE FILELISTONLY to determine if this is a database backup:

RESTORE FILELISTONLY
FROM DISK='C:\MyDatabase.dat'

You can then execute a RESTORE with the desired MOVE options.

RESTORE MyDatabase
FROM DISK='C:\MyDatabase.dat'
WITH
MOVE 'MyDatabase' TO 'C:\DBDataFiles\MyDatabase.mdf',
MOVE 'MyDatabase_Log' TO 'C:\DBDataFiles\MyDatabase_Log.ldf'

If you get an error during the RESTORE FILELISTONLY that states the file
isn't a valid backup, you'll need to investigate further. You might try
opening it using a text editor to see of that provides a clue of the file
format.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Christian R" <Christian.Rosseel@pandora.be> wrote in message
news:Zn65f.26124$z_6.1075248@phobos.telenet-ops.be...
> Hello,
>
>
>
> Is there somebody ho can tell me how to import a '.dat' file in Microsoft
> SQL Server 2000 Developer?
>
> The '.dat' file contain a fully database, with many different tables. Each
> of them contain many different rows.
>
> Thank you very much.
>
>
>
> Christian.
>
>
>
>

[Back to original message]