CODEWITHSUNDEEP
sql-serverimportrestore
Bongo Sharp
Bongo Sharp

Reputation: 9610

Import DAT Files into Sql Server 2008

I Recently received a DAT file containing a SQL database, i would like to restore the database into my server for testing purposes, i tried to add it with the Task->Restore->Database but it didn't come up as a valid file when browsing for the DAT file, then if i select it with the "all files" option it will tell me that the file format is invalid. Does anyone know how to load those kinds of files into SQL Server 2008?

Thanks

Upvotes: 2

Views: 19859

Answers (2)

rjmd
rjmd

Reputation: 170

Just had this exact error and found a much simpler fix.

Change the extension to .txt from .dat and then import the file via the import wizard built into SQL Server or via SSIS. To my understanding the solution in your link should only be necessary for .bak files.

Upvotes: 1

Bongo Sharp
Bongo Sharp

Reputation: 9610

Actually this was the issue. the DAT was a normal .Bak, but the file became corrupted while uploading\downloading from an FTP server... Weird

Regards!

Upvotes: 1

Related Questions